Online Documentation for SQL Manager for Oracle
Setting check options
Use the Options tab of Key Editor to specify the primary/unique key constraint options.
Use this group to toggle the constraint status:
Disabled (disables the integrity constraint)
Enabled (applies the constraint to the data in the table)
Options of this group correlate with the corresponding server constraint behaviour parameters - VALIDATE and NOVALIDATE:
No validate (ensures that all new DML operations on the constrained data comply with the constraint)
Validate (specifies that all old and new data also complies with the constraint)
Select this option to enable the deferrable group which allows you to specify one of the following:
Initially immediate (indicates that Oracle should check this constraint at the end of each subsequent SQL statement)
Initially deferred (indicates that Oracle should check this constraint at the end of subsequent transactions)
Use this group to specify whether a constraint in NOVALIDATE mode is to be taken into account for query rewrite:
Rely (activate an existing constraint in NOVALIDATE mode for query rewrite in an unenforced query rewrite integrity mode)
Note: This group is only available on editing an existing check constraint.
This group defines exception handling for integrity constraints. The group is not available for check constraints.