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

 

Status

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)

 

Validation

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)

 

Rely

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.