Constraint name
Check condition
Comment
OK
Cancel
Apply
Constraint name
Check condition
Comment
OK
Cancel
Apply
Constraint name
Optional: Type a name for the check constraint that you're defining. This name:
If you do not specify a constraint name, one is generated for you.
Check condition
Use this box to specify the check condition for the constraint that you're defining. Type the 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: Type a comment to document the check constraint that you're defining. You can type up to 254 characters, including embedded blanks.