Difference between Primary Key and unique key ?

 Posted by Sriramnandha on 1/21/2012 | Category: Sql Server Interview questions | Views: 2883 | Points: 40

Primary Key Restrict duplicate values and null values each table can have only one primary key,default clustered index is the primary key.

unique key restrict duplicate values and allow only one null value. default non clustered index is an unique key

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Sriramnandha