Can we create clustered index on non primary key column
Answer Posted / pavan kumar
YES, We can create a clustered index on a non-primary
column. Check the folowing queries...
CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)
CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)
| Is This Answer Correct ? | 57 Yes | 6 No |
Post New Answer View All Answers
What is table value parameters (tvp)?
what is sql server? : Sql server database administration
What are various limitations of the views?
When you use @@error and try-catch?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How to return the second 5 rows in ms sql server?
List out what other servers you can use with ssrs?
What's the information that can be stored inside a bit column?
What are the types of ssrs?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Difference between report and query parameter.
Do you know the different ddl commands in sql?
What is compression - row-level and page-level compression?
What is the difference between resultset and resultsetmetadata?
What is a mixed extent?