The UNIQUE constraint does not permit a null value for the column.

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

The NOT NULL constraint ensures that null values are not permitted for the column.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.