List tables in MS Access database

Michal Wrobel - Dataedo Team Michal Wrobel 2018-06-26

Table of Contents:


    Query below lists all tables in MS Access database.

    Query

    select MSysObjects.name
    from MSysObjects
    where
       MSysObjects.type In (1,4,6)
       and MSysObjects.name not like '~*'   
       and MSysObjects.name not like 'MSys*'
    order by MSysObjects.name
    

    Columns

    • name - table name

    Rows

    • One row represents one table in the database
    • Scope of rows: all tables in the database
    • Ordered by name

    Notes

    Note that we have excluded system tables (names starting with ~ or Msys).

    Sample results

    Query result shows names of all tables in the database.

    sample results

    You could also get this

    Get this interactive HTML data dictionary in minutes with Dataedo.

    See live HTML data dictionary sample

    Try for free

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept