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

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2549

Can we use where clause with group by?

945

What is the osql utility?

1033

How do I create a trace in sql server?

1085

Do you know what is bit data type and whats the information that can be stored inside a bit column?

995

What is stretch database in sql server?

1113

What is NOT NULL Constraint in sql server 2012?

1043

What is a hint?

1051

What is table-valued sub query?

1024

How to select true false based on column value in sql server?

1079

Explain the properties of subqueries in sql server?

1132

How to provide column names in insert statements in ms sql server?

1220

What is the distinction amongst delete and truncate?

1110

How to change a login name in ms sql server?

1127

Name 3 ways to get an accurate count of the number of records in a table?

1084