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 create database syntax? : Sql server database administration

1052

How is foreign key related to primary key?

913

What is @@rowcount in sql?

950

What is the use of @@spid?

957

What are the types of joins in sql?

1055

What are the basic features of a trigger in ms sql server?

1109

How to search for a string in all stored procedure in sql server?

950

How to Sync Two SQL Azure Databases?

119

How do you set a trace flag in sql server?

996

What is a cube? : sql server analysis services, ssas

945

What is an execution plan? When would you use it?

919

How can i Relate Tables in SSIS

1033

Where cross join is used?

903

Why use “pivot” in sql server?

1041

Why is normalisation important?

899