What is a unique constraint?

A unique constraint enforces uniqueness on a combination of one or more columns in a global or central table; and there can be multiple unique constraints defined for a single table.

Any insert or update operation that would violate a unique constraint will raise an exception.