Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding PK index
Message
From
17/01/2016 13:47:50
 
 
To
17/01/2016 10:38:16
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01629831
Message ID:
01629853
Views:
32
>
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform