Can we create clustered index on non primary key column

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are temporal tables in sql server 2016?

485


What is difference between cte and view?

528


List out different types of normalizations in sql server and explain each of them?

563


What is the exact numeric data type in sql?

551


What are Row versions of DataRow?

615






How to test odbc dsn connection settings?

538


How can a database be repaired?

571


How to count rows with the count(*) function in ms sql server?

542


What is history table in sql server?

509


Does windows server 2016 come with sql server?

505


Where is localdb stored?

570


What is the new security features added in sql server 2016? : sql server security

623


How do I find information about the install locations for the various instances running on a computer?

560


What is 5nf in normalization form?

578


What does <> symbol mean?

560