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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2006-11-08 : 10:33:15
|
| Hi.I have some tables and i want to view their Relationships.Let's say i have a table named "Help"i use the Stored procedure "sp_fkeys" to get the Fkey-keys of the tables that refear table "Help". What i cannot do is the opposite. Meaning that i want to see the tables that "Help" is refearing. And not sp_pkeys does not work Any ideas? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-08 : 10:52:56
|
| You need to use the correct parameters, for examplesp_fkeys @pktable_name = [parent]returns the information about the foreign keys that refer to the primary key in [parent]sp_fkeys @fktable_name = [child]returns the information about the primary keys that [child] refers to |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2006-11-08 : 11:06:07
|
| fkeys and pkeys on the tables, got it.Thanks! |
|
|
|
|
|
|
SQL table relationships problem.