Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54239 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
What is data compression?
What are the 3 types of schema?
What is meant by referential integrity?
What samples and sample databases are provided by microsoft?
Name and describe few console utilities for ssrs?
How do you delete a data source?
 Explain what is sql override for a source taLle in a mapping?
How to insert data into an existing table?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is difference between unique and primary key?
Can we delete data from a view?
How to create stored procedures with parameters in ms sql server?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Why olap is used?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
