Yes, But on that table primary key should be created with non-clustered i

Can we create clustered index on non primary key column

Question Posted / vidit

Answer Posted / vidit

Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain indexing and what are the advantages of it?

1018

How to create function with parameter in sql server?

1097

What is similarity and difference between truncate and delete in sql?

1089

How to use old values to define new values in update statements in ms sql server?

1258

How to use linked server?

1181

what is a join and explain different types of joins? : Sql server database administration

953

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

925

How do I view a trc file?

932

How many types of schemas are there?

1036

What are the drawbacks of reporting in ssrs?

149

What are locks in sql?

972

What are different backups available in sql server?

1063

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1133

What are “phantom rows”?

1650

What is a domain constraint give an example?

1043