Query below lists all tables in MS Access database.
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
- name - table name
- One row represents one table in the database
- Scope of rows: all tables in the database
- Ordered by name
Note that we have excluded system tables (names starting with ~ or Msys).
Query result shows names of all tables in the database.
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.
See live HTML data dictionary sample