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 a synonym for manipulation?

645


What is 1nf 2nf?

655


What is the difference between grant and with grant while giving permissions to the user?

612


Explain what is meant by replication of database?

620


What is the query and subquery?

704






What are the difference between data mart and data warehouse? : sql server analysis services, ssas

597


What is catalog views?

703


What is normalization? Describe its different types.

673


What is difference between getdate and sysdatetime in sql server 2008?

686


What is sub-query in sql server? Explain its properties.

683


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1595


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

603


Explain the functionalities that views support?

766


What is instead of trigger sql server?

589


Explain index in sql server?

670