| Primary Key | Unique |
|---|---|
| A primary key is a constraint that ensures that a field or column of a sql table does not hold duplicate or null values | Unique is a constraint that ensures that a field does not have duplicates but allows null values. |
| There can be only one primary key in a sql table | A Unique constraint can be applied on more than one field. |