can primery key be a non clustered index?

Answer Posted / navneet sharma

Primary cannot be a non clustered index because when you
are creating primary key on a column then by defualt
cluster index will created on that column.

Is This Answer Correct ?    8 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the distinction amongst delete and truncate?

593


What is ms sql server service broker?

530


How to use the inserted and deleted pseudo tables?

548


Explain about Views?

614


Do you know what are pages and extents? : SQL Server Architecture

571






Do you have any idea about the tcl commands?

561


How to rebuild indexes with alter index ... Rebuild?

600


How do I find the sql server version?

537


What does asynchronous call backs means?

631


Can two tables have the same primary key?

573


How many types of attribute relationships are there? : sql server analysis services, ssas

594


How can we delete a table in sql server?

561


What is bit data type?

636


What are various ways to enhance the ssrs report?

544


What is the stored procedure?

572