we can creta clustered index on non primary column. create table abc(eid i

Can we create clustered index on non primary key column

Question Posted / ashok

Answer Posted / ashok

we can creta clustered index on non primary column.
create table abc(eid int,ename varchar(50))
create clustered index abc_clustered on abc (eid)

Is This Answer Correct ?

67 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What are the new features in sql server 2016?

933

What are the grouping functions?

893

What is the beast way to write CTE in SQL Server ?

996

What is the use of nvl work?

960

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

900

What are the advantages of using stored procedures in sql server?

971

What is sql sandbox in sql server?

1160

Can you explain different types of locks in sql server?

916

What protocol does sql server use?

895

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1022

What is clustered index

963

what is hash nonclustered index

919

Define master database?

1002

What is sql or structured query language?

1096

What is nested transaction?

1057