March 3, 2012

Difference between Primary Key and Unique Key

  •     Both Primary Key and Unique Key gives uniqueness of the column on which they are defined.
  •     By default Unique Key creates a nonclustered index whereas Primary Key creates a clustered index on the column.
  •     A Primary key value cannot be NULL whereas Unique Key allows only one NULL.

No comments: