Return names of all tables in database: SQL

[mkingrey]

I would like to return the names of all tables in my database using SQL. I'm using an Access database. Is there a way to do this?

Thanks

 

[Golom]

Run this SQL

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=1));

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[PHV]

I'd replace this:
WHERE (((MSysObjects.Type)=1));
with this:
WHERE MSysObjects.Type In (1, 4);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886