SQL to get a list of tables in the database

Dom · Oct 7, 2003

Dear Newsgroup,

Is there a way to write a query that returns all the
tables in an Access database?

Thanks,

Dom

Lynn Trapp · Oct 7, 2003

SELECT Name
FROM MSysObjects
WHERE Type = 1
AND Name NOT LIKE "Msys*";