Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Avoiding selection primary key in sysindexes
Message
 
À
04/03/2008 23:08:32
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01298781
Message ID:
01298787
Vues:
15
Add a where clause:

WHERE NOT IN (SELECT key_column_usage.COLUMN_NAME FROM information_schema.table_constraints
INNER JOIN information_schema.key_column_usage
ON table_constraints.constraint_name = key_column_usage.constraint_name
WHERE
table_constraints.constraint_type = 'PRIMARY KEY' AND table_constraints.table_name = 'table_name')

?
Woodie Westbrook
I came, I saw, I compiled.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform