Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RI Set-up Problem
Message
From
30/08/2002 10:56:56
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
RI Set-up Problem
Miscellaneous
Thread ID:
00695434
Message ID:
00695434
Views:
42
SQL2K - DRI problem

Table A is a 1-Many parent of table B
Table A is also a 1-Many parent of table C
Table B has an Fkey to Table C that can be null or have a value

I want to cascade delete from A to B, A to C, and C to B

SQL Server screams at me about "possible cyclical or recursive paths" - or something to that effect.
How can I accomplish this without having to do it all trigger based?

Thanks,
Ken B. Matson
GCom2 Solutions
Next
Reply
Map
View

Click here to load this message in the networking platform