How getting the name names of tables...

[mgonzalez]

Hi

I hope that something could help me.I want through SQL get the name of name of all tables in my database.I am working with access 97.Is this possible??? because I remember that for Oracle is it.

Best ragards

 

[MisterC]

Excluding system tables:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1));