Changing primary key index structure

added by AdaTheDev
3/1/2010 1:10:32 AM

0 Kicks, 123 Views

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.