exploring database schema

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi,

No, there is no other generic way besides
OleDbConnection.GetOleDbSchemaTable.
 
I've found things like GetOleDBSchema.. but (of course) it is
available only for OleDBConnector.
Click to expand...

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

Eric
 
Back
Top