Information schema Or Catalog views

  • Thread starter Thread starter Günther
  • Start date Start date
G

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
 
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.
 
Back
Top