I want to know how to obtain the relationships of foreing keys when they have diferent names in diferent tables using SQL querys from VB.net in SQL Server 2000.
Example:
Table Person
----
IDPerson
Name
Address
Table Customer
-----
IDCustomer
.
.
.
Table Employee
-----
IDEmployee
.
.
.
The dependencies are:
IDPerson-->IDCustomer
IDPerson-->IDEmployeeI think you need to query sysforiegnkeys, syscolumns and sysobjects|||Thanks, it wasnt easy but it's done.
Rodrigo
Showing posts with label dependences. Show all posts
Showing posts with label dependences. Show all posts
Subscribe to:
Posts (Atom)