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.


Check Editor - Setting check options



Use this group to toggle the constraint status:

RadioButton Disabled (disables the integrity constraint)

RadioButton 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:

RadioButton No validate (ensures that all new DML operations on the constrained data comply with the constraint)

RadioButton Validate (specifies that all old and new data also complies with the constraint)


CheckBox Deferrable

Select this option to enable the deferrable group which allows you to specify one of the following:

RadioButton Initially immediate (indicates that Oracle should check this constraint at the end of each subsequent SQL statement)

RadioButton 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:

RadioButton No rely

RadioButton 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.


Exceptions processing

This group defines exception handling for integrity constraints. The group is not available for check constraints.