- 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 doesn't allow NULLs, but unique key allows one NULL only.
UNIQUE Vs PRIMARY KEY
Subscribe to:
Post Comments
(
Atom
)
0 comments :
Post a Comment