Information schema Or Catalog views

[Günther]

Hello newsgroup!

Does Access have catalog views to get information about tables and their
columns contained in an *.mdb, which can be queried by SQL ??

Thanks in advance

Günther

 

[Douglas J. Steele]

Yes to tables (it's in the normally hidden MSysObjects table):

SELECT Name
FROM MSysObjects
WHERE Type IN (1, 4, 6)
ORDER BY Name;

Tables actually in the MDB have an object type of 1, linked tables have an
Object type of 6, and tables linked using ODBC (often referred to as
pass-through tables) have an object type of 4

No to columns.