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
How to search for a string in all stored procedure in sql server?
Explain difference between control flow and data flow?
What is the main purpose of having conversation group?
Can a function call a stored procedure in sql server?
Write a query for primary key constraint with identity key word?
What is sql server used for?
How to get the number of affected rows?
do you know how to configure db2 side of the application? : Sql server database administration
How extra digits are handled with numeric data type literals?
Tell me what is log shipping?
What is an entity-relationship diagram (erd)?
What is the bookmark lookup and rid lookup?
How to create view in stored procedure sql server?
Can you explain various data region available in ssrs with their use?
What is identity?