Changing primary key index structure(www.adathedev.co.uk)
submitted by
AdaTheDev(123) 2 years, 2 months ago
Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it.
|category: Database
|Views: 3
tags:
SQLServer SQL Database another
Everyones tags:
Your Tags: