Primary key uniquely identifies a record in a table, while unique key ensures that all values in a column are distinct.

• Primary key can't have null values, while unique key can have one null value.

• A ta...read more

Primary key will not accept NULL values whereas Unique key can accept NULL values. A table can have only one primary key whereas there can be multiple unique key on a table