Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54263 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / kaveri
Clustered index can be created in non primary key column
but the primary key column shoulb be created with non
clustered index. because by default primary key will have
clustered index. Each table should have only one clustered
index. So first we have to remove clustered index from
primary key column by creating it with non clustered index
and then create clustered index for non primary key column.
Note: The non primary key column should contain unique
values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Tell me something about security and sql azure?
What is the significance of master, tempdb and model databases?
What happens when transaction log is full?
Can you leave a union at any time?
How do I port a number to sql server?
How to Check if table exists in sql server?
What is change tracking in sql server?
what is a traditional network library for sql servers? : Sql server database administration
Which are the important points to note when multilanguage data is stored in a table?
What is pessimistic concurrency?
What is sql sandbox in sql server?
What are the advantages of using a stored procedure?
Explain temporary table vs table variable by using cursor alternative?
What is side by side migration in sql server?
Explain what is the purpose of sql profiler in sql server?
