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
    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
    My Story Printed in Sikh Review Sept 2015 Issue Convert's Corner Oct 19, 2015
    Sakhis In The Footprints Of Guru Nanak... Redeeming Noorshah-the Magical Woman Of Kamroop History of Sikhism Mar 18, 2015

  3. 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. 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. 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?
     

Share This Page