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 / laxman2610

Answer Posted / laxman2610

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 ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

how we use window authentication connection with sql server.?

1209

Explain foreign key in sql server?

1072

What is the Disadvantage of indexed sequential file.

1126

Why do we partition data?

1079

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1065

How to test values returned by a subquery with the in operator?

1251

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1166

What are logical database components? : SQL Server Architecture

1092

How do indexes help, types?

1011

What are the advantages of having an index on the sql server?

973

What are rows and columns?

1063

Why are sql functions used?

1181

How to use linked server?

1269

How do I open port 1433?

985

What is normalization? Describe its different types.

1151