Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54151 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
Explain syntax for disabling triggers?
What is the fillfactor concept in indexes?
What are the restraints imposed on the table design by a merge replication?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is the use of group by clause?
What is the difference between a check constraint and a rule?
Explain the architecture of ms sql reporting service?
List the various tools available for performance tuning?
Can we create clustered index on composite key?
Why use triggers?
Explain the types of indexes.
What are types of scd? : sql server analysis services, ssas
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is save transaction and save point?
What is row_number function?
