Can we create clustered index on non primary key column
- 20 Answers
- 51613 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / kaveri
Clustered index can be created in non primary key column
but the primary key column shoulb be created with non
clustered index. because by default primary key will have
clustered index. Each table should have only one clustered
index. So first we have to remove clustered index from
primary key column by creating it with non clustered index
and then create clustered index for non primary key column.
Note: The non primary key column should contain unique
values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get @@error and @@rowcount at the same time?
What are the properties of the transactions?
What are four major operators that can be used to combine conditions on a where clause?
Why should we go for stored procedures? Why not direct queries?
What is the advantage of sql server?
Can we use where clause in union?
What is msdb database? : SQL Server Architecture
How to create dbo table in sql server?
Do you know what are the steps to process a single select statement?
Explain can SSRS reports Cache results?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is a user-defined function in the sql server and what is its advantage?
What is an index. What are the types?
what is raid? : Sql server database administration
Who is the owner of a schema in ms sql server?
