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.