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_K eys, 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.

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

Jason

et wrote:

> 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_K eys, New
> Object() {Nothing, Nothing, strTableName, Nothing})