State similarities between Primary key and Unique Key?

 Posted by vishalneeraj-24503 on 3/6/2014 | Category: Sql Server Interview questions | Views: 670 | Points: 40
Answer:

Although both Primary key and Unique Key enforces uniqueness on the columns on which they are defined.There are some similarities between them which are as follows:-

-> Primary key and unique Key columns allow only unique values.
-> Primary key and unique Key columns will always avoid duplicates.
-> Both Primary key and unique Key columns uniquely identifies each Row or Record in the table they are defined.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response