Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete from a table
Message
 
 
À
30/10/2009 19:26:10
Moacyr Zalcman
Independent Consultant
São Paulo, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Desktop
Divers
Thread ID:
01432469
Message ID:
01432472
Vues:
36
You can add your FK conditions into WHERE clause.

>
>I want to delete rows from a table that match some condition. But some of them cannot be deleted due to FK constraints.
>Is there a way to keep these rows but delete the others without filtering?
>
>TIA
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform