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
Difference between group by clause and having clause in SQL?
What does Master database contains?
Can binary strings be converted into numeric or float data types?
Explain can SSRS reports Cache results?
How to receive output values from stored procedures?
What is the difference between a view and a stored procedure?
How many types of subqueries are there in sql server?
What does executeupdate return?
What is stored in the mssqlsystemresource database? : sql server database administration
Can primary key be null?
How column data types are determined in a view?
Explain log shipping?
What methods do you follow to protect from sql injection attack?
what is datawarehouse?
Name some of the open source software that you can use in alternative to SSR?