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 |
|
AdamC
Starting Member
1 Post |
 Posted - 2004-05-06 : 22:01:29
|
| I have a database in Access, that has a table with two fields that both specify an "ON DELETE CASCADE" constraint to another table.When I try to create the same table structure in SQL Server, I receive a cyclic reference error.Could someone please tell me why this is happening, and point me in the direction of a good site that explains how to resolve this issue?Thanks for your help.Adam Coganwww.ssw.com.au |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-06 : 22:35:11
|
Hi AdamI think books online says it best :quote:
The series of cascading referential actions triggered by a single DELETE or UPDATE must form a tree containing no circular references. No table can appear more than once in the list of all cascading referential actions that result from the DELETE or UPDATE. The tree of cascading referential actions must not have more than one path to any given table.
Does that sound like a likely culprit in your database ? You might be best off writing a trigger on that table if you have some complex relationships.Damian |
 |
|
|
|
|
|
Constraints causing cyclic reference errors