Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-18 : 08:18:35
|
| Mahesh writes "how can i find the names of all tables in a database using sql statement? my backend is msaccess 2000 & front end is vb6. i have to display the names of the tables of a database on vb form. i just want to know the sql statement used to do so. if i get it i'll be greatefull 2 u." |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-11-18 : 09:49:16
|
| I believe Access exposes its TableDef objects to be interrogated by VB which you can create a looping structure to list the TableDef.Name for each in the database. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Table Selection