Constraint name
Check condition
Comment
OK
Cancel
Constraint name
Check condition
Comment
OK
Cancel
Constraint name
This field displays the constraint name currently specified for the check constraint. To change the constraint name, type a new name for the check constraint. This name:
Check condition
This box contains the check condition currently specified for the constraint that you're defining. To change the check condition, type the new condition in the box.
Examples
SALARY > 10000
DEPTNO BETWEEN 10 AND 100
JOBTYPE IN ('Sales', 'Shipping', 'Manager')
Attention: Check constraints are not checked for inconsistencies, duplicate conditions, or equivalent conditions. Therefore, contradictory or redundant check constraints can be defined resulting in possible errors at execution time.
Comment
Optional: This field contains the comment currently specified for the check constraint. To change the comment, type the new comment in this field. You can type up to 254 characters, including embedded blanks.