Sunday, January 9, 2011

Difference between primary key and unique key ?


Both provides uniqueness of records.
Primary key does not allow null values. but unique key allows one null value.
Primary key creates clustured index on the column, unique key creates nonclustured index on the column.

No comments:

Post a Comment