can primery key be a non clustered index?

Answer Posted / raju

No. If a table have primary key column automatically it is
clustered index. if a table have other than primary key
it have non clustered index. so answer of the question is it
doesn't support non clustered index in the primary key column

Is This Answer Correct ?    22 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Geography datatype in SQL Server

708


What are the steps you will take to improve the performance of a poor performing query?

680


What is difference between views and stored procedures?

604


in the physical file layout, where should the transaction log be stored in relation to the data file?

625


What is the use of tempdb? What values does it hold?

647






What is an example of a foreign key?

594


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

632


What is cross join in sql server joins?

701


How to round a numeric value to a specific precision?

650


What are audit control procedures?

668


What is the difference between locking and multi-versioning?

622


Explain what is dbcc?

676


What do you mean by an execution plan?

670


What is an index in a database?

618


List some of the rules that apply to creating and using a ‘view’

605