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