Unique Constraints

Definition: Unique constraints allow database administrators to specify that a column may not contain duplicate values. When you create a new unique constraint, the DBMS checks the column in question to determine whether it contains any duplicate values. If the table contains preexisting duplicates, the constraint creation command fails. Similarly, once you have a unique constraint on a column, attempts to add or modify data that would cause duplicates to exist also fail.