List tables in MS Access database

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.