The UNIQUE Constraint prevents identical values in a particular column.The UNIQUE constraint provide a guarantee for uniqueness for a column or set of columns.

EAMPLES:-

ADDING UNIQUE KEY

DROPING UNIQUE KEY