How do I retrieve all tables in a database using SQL in Ms Access?

Question

Possible Duplicates:
can we list all tables in msaccess database using sql?
How to get table names from access?

http://stackoverflow.com/questions/2076422/access-get-all-tables — Mitch Wheat, Apr 01 '11 at 05:07
http://stackoverflow.com/questions/201282/how-to-get-table-names-from-access — Mitch Wheat, Apr 01 '11 at 05:07

score 2 · Accepted Answer · answered Apr 01 '11 at 05:05

2

SELECT name
from msysobjects
WHERE type=1 and flags=0
;

answered Apr 01 '11 at 05:05

RichardTheKiwi

1 Answers1