Browsing database structure

  • Thread starter Thread starter R_O_O_K
  • Start date Start date
R

R_O_O_K

Hi!

I need to view the structure of a DBMS (ie what databases does it
contain and what is their structure). ADOX takes care of that in OleDb,
but what tool should I use with MSSQL, Postgres or any other?

Regards!
Michal Ziemski
 
If you are using the OleDb data provider for .NET, you can use
OleDbConnection.GetOleDbSchemaTable.

If you are using database-specific data providers, the closest you can come
is to use ordinary SELECT statements against the SQL92/99 standard
INFORMATION SCHEMA views. If you are using database-specific data providers
and your database doesn't support the INFORMATION SCHEMA views, you'll need
to use the database-specific metadata tables.

Interestingly ODBC exposes the equivalent of the OLE DB schema tables
(SQLTable) but the Odbc data provider doesn't support it.

Hope this helps,
Bob Beauchemin
http://staff.develop.com/bobb
 
Back
Top