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 ...