Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54804 Views
- ABC, CTS, I also Faced
- E-Mail Answers
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 stop a loop early with break statements in ms sql server?
How do you open a cluster administrator?
What is user defined datatypes and when you should go for them?
What is named calculation? : sql server analysis services, ssas
What is a coalesce function?
Difference between Logical Page and Physical Page in SSRS.
What are the different type of replication in sql server?
What are filegroups in sql server?
How to delete database objects with "drop" statements in ms sql server?
What is trigger and different types of Triggers?
How to manipulate data from one table to another table ?
How to Insert multiple rows with a single insert statement?
Explain the difference between cross join and full outer join?
Do you know exporting and importing utility?
what is a check constraint?
