Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RI Set-up Problem
Message
De
30/08/2002 10:56:56
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
RI Set-up Problem
Divers
Thread ID:
00695434
Message ID:
00695434
Vues:
41
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform