Can we create clustered index on non primary key column
Answer Posted / laxman2610
Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
How can you manage sql azure security?
Explain mixed authentication mode of sql server?
Can two different columns be merged into single column? Show practically?
Why use identity in sql server?
Can sql server 2016 run on windows 7?
How can you list all the table constraints in a database?
What are the transaction properties?
How many types of the database links?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What do you understand by physical_only option in dbcc checkdb?
What is the difference between indexing and hashing?
Mention the different authentication modes in sql server.
How can a user-defined datatype be created?
Explain what is the difference between union and union all?
whats the maximum size of view state??