What is the difference between primary key and unique key?

 Posted by Rajni.Shekhar on 4/17/2012 | Category: Sql Server Interview questions | Views: 1469 | Points: 40

Difference between Primary Key and Unique Key

1) Primary key creates a clustered index on column whereas unique key creates a non-clustered index on column.

2) NULL is not allow in case of primary key but in unique key one null is allowed.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response