how to get name of all tables in msaccess database
Database
2
Posts
2
Posters
0
Views
1
Watching
-
i have a MS-Access database db1.mdb now i want to get the name of all the tables in my program which are in db1 like in oracle "select 8 from tab" which returns names of all tables do we have any such query in Ms-Acess
It's generally good practice to add tables to your database that provide a definition of the database structure, so if you do that you can of course retrieve table names that way. The other option is to use ADOX. Do an MSDN search on ADOX - it provides methods for enumerating all objects in a database. Robert