UNIQUE Vs PRIMARY 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 doesn't allow NULLs, but unique key allows one NULL only.

0 comments :

Post a Comment

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger