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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2008-08-02 : 02:28:11
|
| Hi All,I have a Problem in deleting a table, because The PK of this table is referred in many tables as Foreign Key. So, i need to find out all those tables in which it was depending on the Primary Kay Table.How to find those Tables.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-02 : 05:56:05
|
| use sp_depends stored procedurehttp://msdn.microsoft.com/en-us/library/ms189487.aspx |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-04 : 05:00:52
|
| orEXEC sp_help 'tablename'MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to find out the FK references.