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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-21 : 09:43:42
|
| jurgen writes "In which order are Foreign Key Constraints with cascading deletes executed and can I change/determine that order? I have tables A, B and C with cascading deletes from A to B and A to C, But B can't be deleted if C exists. If I delete a record from A which table gets to be checked first? If after A C gets deleted first and than B, that would execute OK. But if after A B gets deleted first it will give an error because C still exists. SQLServer 2003 on Windows Server 2003 standard edition SP1. Hope this question is hard but not to hard. If this questuion isn't hard enough then please answer in Dutch." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-07-21 : 11:11:37
|
| Is it possible to restructure to A->B->C? Why isn't the B->C link formally defined? |
 |
|
|
|
|
|
execution order of constraints