table relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

et - 28 Dec 2004 02:50 GMT

How do I programmtically get the relationships of a table??

I can get the list of columns:
dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid., New Object() {Nothing,
Nothing, strTableName, Nothing"})

, but when I change it to Foreign_Keys, no data is returned.

dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, New
Object() {Nothing, Nothing, strTableName, Nothing})

Reply to this Message

Jason - 28 Dec 2004 13:14 GMT

ET,
What database are you using? If it's SQL, try accessing the system
tables for getting at this information.

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

Jason

> How do I programmtically get the relationships of a table??
>
[quoted text clipped - 6 lines]
> dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, New
> Object() {Nothing, Nothing, strTableName, Nothing})

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...