Adding a UNIQUE Constraint |
A UNIQUE constraint can be applied to one or more columns of a table at the time it is created. A column that has a UNIQUE constraint cannot have any two tuples with like values, but may contain null values. The UNIQUE constraint must be applied when a column is first created.
Related topic:
Creating
a Table
Setting Column and Table Constraints
Adding a Foreign Key While Creating a Table
Constraint Syntax