Obtaining a list of tables in an ODBC database

[justinhanson]

Hi,

From VB.NET, I need to obtain a list of all of the tables that exist in an ODBC database.

Can anyone please tell me how this can be done?

Thanks!

 

[stevexff]

Depends on the ODBC database. For SQL Server 2000, an SQL call of

EXECUTE sp_tables

will do it (includes system tables). You may need a separate subclass for each database type if you need to be flexible enough to work with multiple database vendors and/or products.

 

[paulrw1]

You will want to look at the schema for the table. Do a google search for an example.