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

Is the primary key column of a table an index in ms sql server?

963

What do you mean by the term 'normalization'?

1215

Who developed sql server?

941

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

935

How to convert a table data in XML format in sql server?

2545

Define model database?

985

What is reportserver and reportservertempdb ?

152

List out some of the requirements to set up a sql server failover cluster?

1034

Can you tell me some of the common replication dmv's and their use? : sql server replication

928

What is view in sql?

911

Can we store videos inside the sql server table?

987

What is precedence constraint?

987

Does partitioning ssd reduce performance?

898

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1024

What is purpose of normalization?

950