Code snippets, technical articles, tips on computing and programming...
What's the difference between a primary key and a 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 unique creates a non-clustered index by default. Another major difference is that, primary key does not allow NULLs, but unique key allows one NULL only.
No comments
:
Post a Comment
Your Comment and Question will help to make this blog better...
No comments :
Post a Comment
Your Comment and Question will help to make this blog better...