Retrieving all tables names from Access Databse.

Question

I want to retrieve all the table names from a access database to check that the table that should be there are there. I also would like to retrieve all the column names foreach table to make sure that is correct.

I have been searching for about an hour now and I can't find what I'm specifically looking for... or maybe I'm just using the wrong key words. ;)

Anyway. Please help.

Thanks

Answer 1

Hi

Use the below query:

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
(Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;

Thanks -- Vj

http://dotnetvj.blogspot.com