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 |
|
darenkov
Yak Posting Veteran
90 Posts |
 Posted - 2005-01-15 : 01:53:24
|
| Hi,I have created my tables and referenced them to each other with the respective PKs and FKs. I was just wondering if there is an option with SQL Server 2000 that will automatically cascade the deletes from related tables when I remove an item?cheers |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-15 : 02:00:53
|
| In Books Online, type in "cascading actions" at the index tab. This should give you all the information you need to set it up. Let us know if you have any questions.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
cascading deletes with sql server 2000