13.19.2 Defining check constraints

You can define a check constraint by specifying CHECK in the CREATE TABLE definition SQL statement and the constraint condition for table values as a search condition. Also, to use the check pending status, specify USE in the pd_check_pending operand, or do not specify (omit) the operand.

Organization of this subsection
(1) Limitations on tables for which check constraints are defined
(2) Notes when defining a check constraint

(1) Limitations on tables for which check constraints are defined

This subsection describes limitations that apply to the definition of tables for which check constraints are defined and to modification of the definitions of such tables.

(a) During table definition (CREATE TABLE)
(b) During table modification (ALTER TABLE)

(2) Notes when defining a check constraint