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?
Printable View
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?
please find a related discussion [URL="http://www.sql-server-performance.com/tips/clustered_indexes_p1.aspx"]here[/URL].
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.
Hi mobin,
It is possible to create more than one clustred index on a table.
so You answer is wrong...
table can have only one clustered index, and it can have more than one non-clustered index
one table can have one clustered index and 249 non clustered index.