Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How Do I Print A List Of Database Object Names?

Discussion in 'Information Technology' started by AlfUlz, Jul 28, 2006.

  1. AlfUlz

    AlfUlz
    Expand Collapse
    Guest

    I want to print the list of database object (tables, queries, forms, reports,
    etc.) names for my database. Anybody know how to do this easily?
     
  2. Loading...

    Similar Threads Forum Date
    In The Footprints Of Guru Nanak- Fourth Journey In Punjab Sikh Sikhi Sikhism Dec 22, 2016
    In The Footprints Of Guru Nanak-Fourth Itinerary Sikh Sikhi Sikhism Dec 18, 2016
    Footprints Of Guru Nanak In Sri Lanka History of Sikhism May 27, 2016
    Sikhism Preserving The Sikh Heritage In Print Sikh Sikhi Sikhism Jan 12, 2016
    Guru Nanak's Foot-Prints In Baghdad's Sands Blogs Oct 22, 2015

  3. OP
    Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    AlfUlz wrote:
    > I want to print the list of database object (tables, queries, forms,
    > reports, etc.) names for my database. Anybody know how to do this
    > easily?


    The documenter function would do that and maybe a lot more than you
    want. Look for it under the tools menu.

    --
    Joseph Meehan

    Dia duit
     
  4. OP
    Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Use the MSysObjects table to list the objects and there names

    e.g List of tables, using Type 1 in the criteria

    SELECT MSysObjects.Name
    FROM MSysObjects
    WHERE InStr([Name],"~")=False
    GROUP BY MSysObjects.Name, MSysObjects.Type
    HAVING MSysObjects.Type=1

    --
    Good Luck
    BS"D


    "AlfUlz" wrote:

    > I want to print the list of database object (tables, queries, forms, reports,
    > etc.) names for my database. Anybody know how to do this easily?
     
  5. OP
    Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    It's ugly and maybe not complete, but it works!

    SELECT IIf([MSysObjects].[Type]=1, 'TABLE',
    IIf([MSysObjects].[Type]=5, 'QUERY',
    IIf([MSysObjects].[Type]=-32768, 'FORM',
    IIf([MSysObjects].[Type]=-32764, 'REPORT',
    IIf([MSysObjects].[Type]=-32766, 'MACRO',
    IIf([MSysObjects].[Type]=-32761, 'MODULE',
    IIf([MSysObjects].[Type]=-32756, 'PAGE',
    IIf([MSysObjects].[Type]=8, 'RELATIONSHIPS',
    IIf([MSysObjects].[Type]=6, 'TABLE LINKED',
    'Unknown'))))))))) AS ObjectType,
    MSysObjects.Name,
    MSysObjects.Type
    FROM MSysObjects
    WHERE (((MSysObjects.Name) Not Like "~*"
    and (MSysObjects.Name) Not Like "Msys*")
    and ((MSysObjects.Type) Not In (2,
    3)))
    ORDER BY IIf([MSysObjects].[Type]=1, 'TABLE',
    IIf([MSysObjects].[Type]=5, 'QUERY',
    IIf([MSysObjects].[Type]=-32768, 'FORM',
    IIf([MSysObjects].[Type]=-32764, 'REPORT',
    IIf([MSysObjects].[Type]=-32766, 'MACRO',
    IIf([MSysObjects].[Type]=-32761, 'MODULE',
    IIf([MSysObjects].[Type]=-32756, 'PAGE',
    IIf([MSysObjects].[Type]=8, 'RELATIONSHIPS',
    IIf([MSysObjects].[Type]=6, 'TABLE LINKED',
    'Unknown'))))))))),
    MSysObjects.Name;
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "AlfUlz" wrote:

    > I want to print the list of database object (tables, queries, forms, reports,
    > etc.) names for my database. Anybody know how to do this easily?
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page