YES, We can create a clustered index on a non-primary column. Check the f

Can we create clustered index on non primary key column

Question Posted / pavan kumar

20 Answers
55401 Views
ABC, CTS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is pivot and unpivot?

1061

What is attribute hierarchy? : sql server analysis services, ssas

1062

What is nested transaction?

1137

What is the significance of master, tempdb and model databases?

1128

How to apply cascading referential integrity in place of triggers?

1088

Do you know what is a trace frag? Where do we use it?

1040

What is save transaction and save point?

1255

SQL Server Architecture ?

2519

How check triggers in sql server?

1047

what's the difference between delete table and truncate table commands? : Sql server database administration

1038

How many null values we can have in a unique key field in sql server?

1009

Tell me about pre-defined functions of sql?

1156

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119

Does partitioning ssd reduce performance?

929

What purpose does the model database server?

1147