Saturday 14 June 2014

What is the difference between a primary key and unique key.


What is the difference between a primary key and unique key.

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a non clustered index by default. Another major difference is that primary key doesnt allow Nulls, but unique key allows one Null only.

No comments: