Dinamically retrieve existing relations in a database

C

cbolray

Joined
Mar 12, 2007
Messages
1
Reaction score
0
Hello, I´m new in ADO.NET and I don´t know how to dynamically retrieve foreign keys with its parent and child columns from a database. With the sqlConnection method GetSchema("ForeignKeys"), I obtain their names, but no information about de Parent and Child columns is allowed. How can I obtain this information?. For my application, it is supposed that such relations are unknown and I must find them. I am using SQl SERVER 2000

Thanks a lot in advance
 
Last edited:
Back
Top