yes we can create clusterd index on non primary key. but the primary key

Can we create clustered index on non primary key column

Question Posted / madhav

Answer Posted / madhav

yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How self join is different from outer join?

1124

Find nth lowest salary or get nth lowest salary?

1029

How to create new tables with "select ... Into" statements in ms sql server?

992

Define the one-to-one relationship while designing tables.

908

Describe the left outer join & right outer join. : sql server database administration

999

Is sql server difficult to learn?

925

What do you understand by triggers?

928

What is the architecture of ms sql reporting service?

988

What is de-normalization and what are some of the examples of it?

977

Give me a SQL Query to find out the second largest company?

1170

What are the different types of indexes?

1121

What are pessimistic lock and optimistic lock?

1083

Can you name some of the dml commands in sql?

1036

What stored by the tempdb ? : sql server database administration

1057

What is query and its types?

920