Can we create clustered index on non primary key column
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 copy the tables, schema and views from one sql server to another?
What is report snapshot in ssrs?
How to access the deleted record of an event?
How do we Backup SQL Azure Data?
If we delete pack Spec what will be the status of pack Body ?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How real and float literal values are rounded?
Define msdb database?
What is de-normalization and what are some of the examples of it?
You want to implement the many-to-many relationship while designing tables. How would you do it?
How to deploy the Report?
How to implement service broker?
What to perform pattern match with the like operator?
Do you know how to implement service broker?
How do you troubleshoot errors in a SQL Server Agent Job?