Help please (I need to know the the tables of a dataBase)

[asmaa]

Hi

I need to know the name of tables that exist in a data base.
I find in some documentation that "select table_name from all_tables" will give me what i need. But when I tried with Microsoft Access I got an error messege telling that the Jet Motors can't find the table "all_tables".

Thanks in advance

Asmaa

 

[smedvid]

Well... one approach is to simply look at the Tables tab under MS Access, provided you have MS Access and permission to open the Access database. The other approach is to use the Table_Def approach which u can look up. Essesntially, look through the database collection and grab table names. htwh.;. Steve Medvid
"IT Consultant & Web Master"