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


"R_O_O_K" <(E-Mail Removed)> wrote in message news:be9dev$lcf$(E-Mail Removed)...
> 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
>