Issue

[nageshkota]

If we create a primary key then automatically it creates an unique clusterd index, but for any table there is only one clusterd index is allowed, If i want to create an uniue clusterd index on other column can i do it? If how?

[debasisdas]

please find a related discussion here.

[mobinsk]

Hi,
As you mentioned above it is not possible to create more than one clustered index or unique clustered index.
So,
For creating new one drop the existing one.

[nageshkota]

Hi mobin,
It is possible to create more than one clustred index on a table.
so You answer is wrong...

[ckarthick]

table can have only one clustered index, and it can have more than one non-clustered index

[Amitaqa]

one table can have one clustered index and 249 non clustered index.