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

what are the different types of replication you can set up in sql server? : Sql server database administration

744


What sql server means?

740


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

664


What is dbcc updateusage?

842


Data table as parameter in sql server?

721






What are functions in the sql server?

790


In which tcp/ip port does sql server run? Can it be changed?

720


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

729


what is the information that can be stored inside a bit column? : Sql server database administration

706


Explain full-text indexing?

688


What information is maintained within the msdb database?

720


Can binary strings be converted into numeric or float data types?

744


What is sharding?

103


Explain concepts of analysis services?

675


How to find out what is the default collation in a database?

789