How to use SQL to query the metadata in Microsoft

问题:

I'm totally new to Access but I'm familiar with SQL Server. I want to know if it's possible to use SQL to query the metadata in Microsoft Office Access? Like SQL Server's sys.tables, sys.columns etc. Thanks in advance.

回答1:

use

SELECT Name
FROM MSysObjects
WHERE Left([Name],1)<>"~"
AND Left([Name],4)<>"MSys"
AND Type In (1,4,6)
ORDER BY Name;

for table names

list of table names and a list of database objects