A unique constraint requires that all non-null values in specified columns must be unique.
In a table with a unique constraint, no two rows can have the same value for the specified column. The unique constraint creates a unique index on the specified columns to enforce this data integrity.