Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dropping constraints
Message
De
15/02/2001 09:09:41
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Dropping constraints
Divers
Thread ID:
00476242
Message ID:
00476242
Vues:
56
Hi,

Does anyone have sample code for dropping foreign key constraints where you don't know the constraint name? All we know is:

table and field name
constraint type (i.e. foreign key cosntraint)
other table involved (in case of fkey)

Specifically - is there a quick way to drop all constraints or constraint of a particular type (fkey) from a table?

Thanks!
Ken B. Matson
GCom2 Solutions
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform