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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-02-01 : 16:11:50
|
| hi guys,i was asked to drop some tables...but before dropping i was asked to check for referential integrity..so where and how can i check this referential integrity???? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-02-01 : 16:35:52
|
| first of all if this is a production system, I would re-name the tables first. If anything breaks you can name them back without having to go through a big recovery effort.sp_help <tableName>will show any foreign key constraints or any other objects that reference the table.Be One with the OptimizerTG |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
referential integrity