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.
| Author |
Topic |
|
michael1
Starting Member
28 Posts |
 Posted - 2004-12-08 : 03:30:12
|
| HiLet 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.RegardsMichael |
|
|
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 |
 |
|
|
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 |
|
|
|
|
|
|
Check whether a relationship already exists !!!