Can we create clustered index on non primary key column
Answer Posted / sandeep
Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to filter out duplications in the returning rows in ms sql server?
Explain what is lock escalation and what is its purpose?
What are the different types of locks in the database?
What happens if we shrink log file in sql server?
What does the update command do?
Can you explain the disadvantages/limitation of the cursor?
Explain sub-query?
What is the difference between TRUNCATE and DROP?
How to make remote connection in database?
How global temporary tables are represented and its scope?
Write a program using SQL queries to find a unique entry in a table.
what is database replication? : Sql server database administration
How to enter binary string literals in ms sql server?
What do you mean by a dependent functionality in a build?
what are constraints? Explain different types of constraints? : Sql server database administration