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


Please Help Members By Posting Answers For Below Questions

How to search for a string in all stored procedure in sql server?

801


Explain difference between control flow and data flow?

754


What is the main purpose of having conversation group?

704


Can a function call a stored procedure in sql server?

749


Write a query for primary key constraint with identity key word?

809


What is sql server used for?

778


How to get the number of affected rows?

764


do you know how to configure db2 side of the application? : Sql server database administration

836


How extra digits are handled with numeric data type literals?

737


Tell me what is log shipping?

784


What is an entity-relationship diagram (erd)?

867


What is the bookmark lookup and rid lookup?

779


How to create view in stored procedure sql server?

761


Can you explain various data region available in ssrs with their use?

763


What is identity?

806