Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55397 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 select all columns of all rows from a table with a select statement in ms sql server?
What do you understand by triggers and mention the different types of it?
What is a full text index?
What is sql server transaction log file?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What are different types of join?
What are the benefits and tasks of object explorer? : sql server management studio
What is for xml in sql server?
How to edit table in sql server 2017?
What do you understand by physical_only option in dbcc checkdb?
What are different types of raid levels?
What are the restrictions applicable while creating views? : SQL Server Architecture
Explain Geography datatype in SQL Server
What is function of master database?
