Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing PK from non-clustered to clustered
Message
From
07/07/2016 08:51:50
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01637980
Message ID:
01638021
Views:
63
>
>The ever increasing identity column is the best candidate for the clustered PK. You made a right switch, by default SQL Server makes PK column clustered. Perhaps you originally somehow made it non-clustered.

Just to clarify - if you create an identity column and make it a primary key, SQL Server (by default) will make it a clustered index.

But simply making a column an identity column (without giving the PK designation) doesn't make it a clustered index (actually no index is created)
Previous
Reply
Map
View

Click here to load this message in the networking platform