what is the difference between unique constraint and primarykey and identifiers

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • prasannas
    New Member
    • Apr 2007
    • 1

    what is the difference between unique constraint and primarykey and identifiers

    what is the difference between unique constraint and primarykey and identifiers?
  • Paru
    New Member
    • Jul 2007
    • 2

    #2
    Unique key allows null values atleast one time but primary key never allows null entries.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      While a unique constraint enforces uniqueness (no duplicate value)
      a primary key enforces not-null(value must be entered ) along with uniqueness.

      Comment

      Working...