Search This Blog

Friday 22 January 2016

PRIMARY KEY Vs UNIQUE constraints in sql server

PRIMARY KEY

  1. Primary key on table columns does not accept NULL values.
  2. Only one Primary key allows on table columns.

UNIQUE

  1. Unique constraints on table columns does accept at least one NULL value.
  2. Unique constraints can create more than one on table columns.

No comments:

Post a Comment