Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54260 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / rima
NO.If the table has the primary key column, then by default
it will have a clustered index on that primary key
cloumn.So if you want to create a clustered index on non
primary key column then you have to create it before
setting a column as the primary key column or u have to
delete the clustered Primary key columns index to create a
new one.but it is recommended to have a clustered index on
primary key column.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
What is the full meaning of dml?
What is the difference between for trigger and after trigger?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What do you understand by SQL*Net?
Do you know what guidelines should be followed to help minimize deadlocks?
What does indexation mean?
How to create a scrollable cursor with the scroll option?
Explain about sql server login?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the boxing and unboxing concept in .net?
What is a recursive stored procedure in sql server?
What is logshipping and its purpose?
What is cdc in sql server?
What are the new security features added in sql server 2012? : sql server security
Explain the difference between functions and stored procedures in sql server?
