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

What is the command dbcc checkdb used for?

1010

What is index in an assignment?

954

What are different types of database indexes?

1104

What are joins in sql and what are the different types of joins?

1014

How to backup SQL Server Reporting Services ?

150

What do you mean by acid?

1001

What is coalesce in sql server?

1056

What gets stored inside msdb database?

1252

How can a user-defined datatype be created?

988

How do you create type- insensitive operator?

1048

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1967

What is an expression in ms sql server?

1079

What is row-level compre?

1004

What is the difference between Stored Procedures and triggers?

1082

What is a join in sql? What are the types of joins?

1108