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
54776 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

How do I find the sql server instance name?

959

Can I delete event logs?

918

What does set rowcount do?

894

What is the Difference Between Primary and Foreign Key?

997

What is dynamic cursor in SQL SERVER?

1072

How does clustered and non clustered index work?

916

How do you delete duplicate records in sql server?

1043

What is update locks?

877

Explain the types of indexes.

1197

Can we store videos inside the sql server table?

958

What are trace flags and mention a few common trace flags used with sql server?

1077

Why is sql server log file full?

1024

What is scalar user-defined function?

1086

What is a livelock?

949

What are translations and its use? : sql server analysis services, ssas

1034