Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding PK index
Message
De
17/01/2016 13:47:50
 
 
À
17/01/2016 10:38:16
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01629831
Message ID:
01629853
Vues:
31
>
>Huh?? A clustered key won't be created automatically unless you specify it as such.

By default (and I think this was mentioned previously in this thread, though I haven't read all of it) - when you create a table in the designer in SSMS and you define a column as a primary key, the SSMS designer will create a clustered index on the column(s) associated with the primary key. Obviously, you might not want that. You can change it, but the question is how many people aren't aware of that default behavior.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform