Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Check whether a relationship already exists !!!

Author  Topic 

michael1
Starting Member

28 Posts

Posted - 2004-12-08 : 03:30:12
Hi
Let me know how to do this using SQl query -
How to check whether a relationship is already set between 2 tables on a particular key. If it is not set then make a relationship.
Regards
Michael

Andraax
Aged Yak Warrior

790 Posts

Posted - 2004-12-08 : 06:58:36
Hello Michael!

It sure is possible. My tip to you is to look up the INFORMATION_SCHEMA views in Books Online. Some of the views contain the information you need. For example, look att INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS and INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE.

/Andraax
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-12-08 : 08:02:37
This should get you started:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41896
Go to Top of Page
   

- Advertisement -