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 |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-03-21 : 13:44:30
|
| Hello,I have two tables:Users [UserId]PK, [LabelName]Docs [DocId]PK, [UserId]FK, [DocUrl]I defined a relation ship in my Docs table.The relationship then appears in both Users tabel and Docs table.I want all Docs to be deleted when a User is deleted.I suppose I need to set Delete Cascade on the Users Table relation, right? And not in the Docs table relationship.Thanks,Miguel |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-21 : 15:36:48
|
Correct, unless you've ever seen water flow (cascade) up a waterfall?  |
 |
|
|
|
|
|
Cascade Delete