The CONSTRAINT Clause

A CONSTRAINT limits the values permitted in a field.

The general syntax is:

CONSTRAINT name {
    PRIMARY KEY | UNIQUE | NOT NULL | REFERENCES foreigntable [(foreignfield1, foreignfield2)]
    [ON UPDATE CASCADE | SET NULL]
    [ON DELETE CASCADE | SET NULL]
}

Example of use:

ALTER tableName ADD CONSTRAINT ...