getOleDbSchema

[Guest]

Hi,
I want to get the tables,columns and constraints in a database.
I understand that the getOleDbSchema method of the Connection object helps.
Could anyone help me with code samples or direct me to appropriate links where I could find out more ?

Thank You
Julian

 

[Miha Markic]

Hi,

There is really no greate deal with GetOleDbSchema.
The first parameter is the type of schema you want while the other (object
array) is the filter.
What it returns is a bit driver specific, speccialy flags and other occult
fields - so you will have to see the results by yourself.
You might also check what does .net help offer on
OleDbConnection.GetOleDbSchemaTable Method
topic.

 

[Mike Collier]

I want to get the tables,columns and constraints in a database.

I understand that the getOleDbSchema method of the Connection object helps

I don't know about .net, but in ado the support for openschema was oledb
provider specific (see inside thread for links to MS documentation on the
matter) . http://81.130.213.94/myforum/forum_posts.asp?TID=59&PN=1

 

[William Ryan]

http://www.knowdotnet.com/articles/getoledbschematable.html