Select this radio button to turn on constraint checking for both referential (foreign key) and check constraints, and to check the table immediately for constraint violations.
If you select this radio button, you can specify an exception table. If you specify an exception table, any row that is in violation of a foreign key or check constraint is deleted from your table and collected in the exception table. The constraints are turned back on again and the table is taken out of the check pending state, regardless of whether errors are detected. A warning (SQLSTATE 01603) is issued to indicate that one or more rows were moved to the exception table.
If you do not specify an exception table and any constraints are violated, only the first violation detected is returned to you. The table is left in the check pending state.
[ Top of Page | Table of Contents | Glossary | Index ]