Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54078 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
Is the log file is a part of file group?
Explain acid?
How to convert binary strings into integers in ms sql server?
In what sequence sql statement is processed?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
How to enter comments in transact-sql statements?
What is the difference between insensitive and scroll cursor?
List the types of recovery model available in sql server?
What are indexes in sql?
What is named query? : sql server analysis services, ssas
What is log shipping?
What is transaction server distributed transaction?
Why functions are used in sql server?
What is normalization 1nf 2nf 3nf?
What are advantages of ssrs or why we should use ssrs?
