Can we create clustered index on non primary key column
- 20 Answers
- 51426 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
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is database black box testing?
Do you know nested transaction?
What are page splits?
What is difference between group by and having?
What is not null constraint?
how you can get the list of largest tables in a database? : Sql server administration
What happens when converting big values to integers?
What are click through reports?
what are the reporting service components in SSRS?
What are the export options of ssrs?
What are recommended options to be used while using db mirroring? : sql server database administration
Can primary key be null?
What is blocking and how would you troubleshoot it? : sql server database administration
What is triggers in ms sql server?
