Saturday, October 25, 2008

Often question comes to mind "What's the difference between Primary and Unique Key"

Primary Key:

  • Enforce uniqueness
  • Never allow NULL value
  • By Default create Clustered Index on column

Unique Key:

  • Enforce uniqueness
  • Allow Null value
  • By Default create Non Clustered Index on column

 

Bandagi!