CODEWITHSUNDEEP
sql-serverms-accessmetadata
user133580
user133580

Reputation: 1509

How to use SQL to query the metadata in Microsoft Office Access? Like SQL Server's sys.tables, sys.columns etc

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.

Upvotes: 1

Views: 2290

Answers (1)

sqlab
sqlab

Reputation: 6436

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

Upvotes: 3

Related Questions