exploring database schema

[Guest]

Hi,

how can I list the following things with ADO.NET in a generic way:

a) list all databases available in a DBMS
b) list all tables within a selected database
c) list the fields (and their type, constraint etc.) with in a table

I've found things like GetOleDBSchema.. but (of course) it is available only
for OleDBConnector.

Is there a generic way like the "Connectionstring"-Wizard does it, too?

thanks

doc

 

[Miha Markic [MVP C#]]

Hi,

No, there is no other generic way besides
OleDbConnection.GetOleDbSchemaTable.

 

[Eric]

I've found things like GetOleDBSchema.. but (of course) it is

available only for OleDBConnector.

The purpose in OleDb is to be generic. You can't get any more generic than that.

Eric