WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / samrat sen
yes,you can only create one clustered index on a table.
| Is This Answer Correct ? | 10 Yes | 12 No |
Post New Answer View All Answers
How can I change procedure name in sql server?
what is a check constraint?
What is CTE in SQL
Explain what are the different index configurations a table can have?
What is the difference between clustered and non-clustered indexes in ms sql server?
How to create an identity column?
What do you understand by recursive stored procedure?
How to drop existing views from a database in ms sql server?
Can two different columns be merged into single column? Show practically?
What are diverse clauses that form a part of sql?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How do I clean up sql server transaction log?
Define outer join?
What is the log shipping?
How to find tables without indexes?