DB2 Version 9.7 for Linux, UNIX, and Windows

Adding check constraints

You can add check constraints to your table or nickname. A check constraint sets restrictions on data added to the table or nickname. Check constraints are enforced when rows in the table or nickname are inserted or updated. You can define a check constraint that references a single column.

Before you begin

To add check constraints, you must have at least one of the following privileges on the table to be altered:

Procedure