SQL Extensions   «Prev 

CHECK Constraint Syntax

Check constraint Syntax

CONSTRAINT If you leave out CONSTRAINT and constraint name, the system names the constraint for you.
CHECK pop-up caption
Condition The condition parameter can be any valid condition that evaluates to TRUE or FALSE. Think of the WHERE clause in a query. The same type of condition that works in a WHERE clause will work in a CHECK constraint.
TYPE_OF_LOG Add the CHECK constraint to a column specification if the constraint deals only with that column.