clustered index without primary key

Question

question

shamim007 asked Sep 17, '18

clustered index without primary key

hi all ,

i need help to create a clustered index but i dont have PK in my table .what is the best way to add a clustered index on my table without PK .

clustered-index-without-pk.txt

thanks

sql-server-2008 clustered-index

clustered-index-without-pk.txt (2.7 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2018-09-17T19:31:36Z

Kev Riley answered Sep 17, '18

First of all, let's gets some facts straight - a primary key does not need to be a clustered index, and a clustered index does not need to be a primary key.

So.... creating a clustered index without a primary key, is as simple as

create clustered index CIX_CredentialHistory on CredentialHistory(ID)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question