Online Documentation for SQL Manager for Oracle

Setting foreign key options


Use the Options tab of Foreign Key Editor to specify the foreign key constraint options.

 

Foreign Key Editor - Setting foreign key 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 or view)

 

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 foreign key constraint.

 

Exceptions processing

This group lets you define exception handling, i.e. specify a table into which Oracle places the rowids of all rows violating the foreign key constraint. Use the Schema and Table or view drop-down lists to specify the table into which exceptions will be stored.