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
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is store procedure?
What are relationships and mention different types of relationships in the dbms
What are the hotfixes and patches in sql server?
How do I start sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is a user-defined function in the sql server and what is its advantage?
What is ms sql server index?
Are null values the same as that of zero or a blank space?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is use of except clause?
What is the command used to check locks in microsoft sql server?
Explain what is the difference between union and union all?
Equi join and non equi join is possible with sql server?
How to create new databases with "create database" statements?