Difference between Primary key,unique key,Alternate Key?

 Posted by Sriramnandha on 6/3/2012 | Category: Sql Server Interview questions | Views: 4047 | Points: 40

Primary Key ==> Is used to uniquely identify records and doesn't allow NULL values.

Unique Key ==> Is also used to uniquely identify records but does allow NULL Values per column combination.

Alternate Key ==> Is another type of Unique key, which is used to identify each record uniquely. This is not a constraint. This is just a terminology.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response