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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 relationships keys

Author  Topic 

sqlclarify
Yak Posting Veteran

56 Posts

Posted - 2008-09-30 : 13:46:17
Is there a way to tell what relationships exist between tables by looking at the primary and foreign keys?

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2008-09-30 : 16:06:30
by 'what relationship' you mean one-to-one, one-to-many?
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-09-30 : 19:31:51
This script will give you that information.

Find Table Reference Levels
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957




CODO ERGO SUM
Go to Top of Page

sqlclarify
Yak Posting Veteran

56 Posts

Posted - 2008-10-10 : 20:38:11
Is there a way to tell just by "looking at the tables and keys" without running a script?

Go to Top of Page
   

- Advertisement -