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

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

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

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index