Primary key constraint
# A primary key cannot allow null (a primary key cannot be defined on columns that allow nulls).
# Each table cannot have more than one primary key.
# On some RDBMS a primary key generates a clustered index by default.

Unique constraint
# A unique constraint can be defined on columns that allow nulls, in which case rows that include nulls may not actually be unique across the set of columns defined by the constraint.