Can we create clustered index on non primary key column
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 are the advantages of partitioning?
Can you move the resources after pausing the node? : sql server database administration
What are the key configuration files for sql server reporting services ?
What is a primary key?
What happens if ntwdblib.dll is missing on your machine?
What were the latest updates to SQL Azure service?
How to generate create function script on an existing function?
how you can configure a running aggregate in SSRS?
List the types of recovery model available in sql server?
Explain syntax for dropping triggers?
How to sort query output in descending order in ms sql server?
Which sql server table is used to hold the stored procedure script?
Difference between uniqe index and uniqe constraint?
Define left outer join?
What is an index in sql?