Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55390 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
explain what is raid and what are different types of raid configurations? : Sql server database administration
What does Master database contains?
What is amo? : sql server analysis services, ssas
What is difference between oltp and olap?
What does the on update no action do?
How the authentication mode can be changed?
Explain partitioned view?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What are the types of stored procedures in an sql server?
how can you check the level of fragmentation on a table? : Sql server administration
What are different types of statement?
How do I create a partition table in sql server?
What is mean by candidate key?
How to transfer an existing table from one schema to another schema in ms sql server?
What is a user-defined function in the sql server and what is its advantage?
