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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get meta data info in ADO.NET 2
How does GetSchema get foreign key constraints? 4
Association missing in dbml generated classes 5
Retrieving tables *and* their relations from database 1
Refresh a datatable afer an update so that child foreignkeys will be changed if necessary 2
Creating XML file with many-to-many relations with a dataset 1
Correct way to retrieve key information for a table during a Stored procedure 2
Caches, Datasets, and Relations 1

Top