IBM Books

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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]