Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54789 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
What are Row versions of DataRow?
What is de-normalization and what are some of the examples of it?
What are data driven subscriptions?
Describe triggers features and limitations?
How you can change the database name in SQL SERVER?
How to define and use table alias names in ms sql server?
Which is the main third-party tool used in sql server?
How do you identify a foreign key?
How can I create a report based on a query? : sql server management studio
Do you know what are the properties of the relational tables?
When columns are added to existing tables, what do they initially contain?
What are rows and columns?
What is the function of inner join?
Explain about temporary stored procedure?
What are the different sql server versions?
