Can we create clustered index on non primary key column
Answer Posted / kaushik ganguly
We know sql server creates a clustered index by default
when we create a primary key. If you create a PK first and
then try to assign a candidate key a clustered index then
it is not possible bcos sql server allows one clustered
index per table.
But...
If you make a candidate key a clustered index and then
define the primary key sql server doesnot create clustered
index for the Primary Key column.
So the answer is yes...you can create a clustered index on
non-pk column :D
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What are the differences between char and varchar in ms sql server?
What is the default server name for sql server?
What is SQL Azure Firewall?
What is raid and what are different types of raid levels?
Explain sql delete command?
What is a rollup clause?
What is the difference between a check constraint and a rule?
How to create prepared statements using odbc_prepare()?
What's new in sql management studio for sql server? : sql server management studio
What is RMS migrations?
Mention what are the different types of ssrs reports?
what is bit datatype? : Sql server database administration
How much is a sql server license?
What is data mart? : sql server analysis services, ssas
What is a performance monitor?