Adding a UNIQUE Constraint

How To

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