Can we create clustered index on non primary key column
- 20 Answers
- 51425 Views
- ABC, CTS, I also Faced
- E-Mail Answers
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 is a covering index?
Tell me what is use of except clause? How it differs from not in clause?
How do you delete duplicate records in sql server?
Explain how would you store your query in an SSRS report or a Database server?
Tell me can we use custom code in ssrs?
How to enforce security in sql server? : sql server security
Write a code to select distinct records without using the DISTINCT keyword.
What is @@error in sql?
When does a workload on SQL Azure get throttled?
How except clause is differs from not in clause?
can you instantiate a com object by using t-sql? : Sql server database administration
Can multiple columns be used in sql group by clause in ms sql server?
Can We Use Data-grids For Our Report In Ssrs?
How do you migrate data from mssql server to azure?
What is cursors?
