Can we create clustered index on non primary key column

Answer Posted / madhav

yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain hostprotectionattribute in sql server 2005?

574


What is a result set object returned by odbc_exec()?

522


What is the purpose of object explorer and its features? : sql server management studio

574


What is change data capture (cdc) feature?

563


You want to implement the many-to-many relationship while designing tables. How would you do it?

533






What is side by side migration in sql server?

508


What are various limitations of the views?

586


What is fill factor and pad index?

512


Explain timestamp datatype?

529


How important do you consider cursors or while loops for a transactional database?

504


How to create a trigger for insert only?

571


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

585


What is acid properties?

567


What are the properties of the transaction?

519


Differentiate between delete and truncate.

555