Online Documentation for SQL Manager for Oracle

Creating/editing foreign key


Use the Foreign Key tab of Foreign Key Editor to create/edit a foreign key constraint and specify its properties.

 

Name

Specify the name of the foreign key to be created, or view the name of the foreign key being edited. Note that the foreign key name must be unique within its schema.

 

CheckBox System named

If this option is selected, Oracle will generate the foreign key name automatically when compiling the foreign key definition.

 

Schema

Use the drop-down list to specify the schema in which the foreign key will be created.

 

Foreign Key Editor - Editing foreign key definition

 

Table or View

Use the drop-down list to select the table or view for which the foreign key is created.

 

The Key fields area allows you to specify one or more table/view columns for the foreign key.

To select a column, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.

 

The Referenced fields area allows you to specify one or more table columns to be referenced by the foreign key.

 

Schema / Table

Use the drop-down lists to select the schema and the foreign table.

To select a column, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.

 

Delete rule

RadioButton None

Produce an error indicating that the deletion would create a foreign key constraint violation.

RadioButton Set NULL

Set the referencing column(s) to null.

RadioButton Delete cascade

Delete any rows referencing the deleted row.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar.