table relationships

[et]

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})

 

[Jason]

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