Online Documentation for SQL Manager for Oracle

Specifying foreign keys


The Foreign Keys tab is provided for setting up table foreign keys.

 

Double-click a foreign key to open the Foreign Key Editor for editing the foreign key.

 

Right-click a foreign key to display the context menu allowing you to create new, edit, or drop the selected foreign key. Using the menu you can also export the list of the table foreign keys to any of supported formats.

 

New table - Specifying foreign keys

 

The Foreign Keys list provides the following attributes of each foreign key of the table:

Foreign Key Name

Columns

Foreign Table

Foreign Columns

On Delete

Disabled

 

For details see Foreign Keys.