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

How to execute multiple stored procedures at one time in sql server?

685


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2030


How do you implement session management in SQL Server mode?

718


What is data file in computer?

705


What is the default value of an integer data type in sql server 2005?

745






How do you clear a log file?

709


Explain ranking functions?

778


What is use of except clause? How it differs from not in clause?

755


What are the different types of backups that exist?

847


What does it mean to normalize data?

664


Can group functions be mixed with non-group selection fields in ms sql server?

697


What is efficiency data?

714


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

734


What is the server name in sql server?

714


What are the difficulties faced in cube development? : sql server analysis services, ssas

794