Tuesday, 30 July 2013

Difference 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 no clustered index. 
Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only.

No comments:

Post a Comment