Online Documentation for SQL Manager for Oracle

Managing foreign keys

The Foreign Keys tab is provided for managing 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, drop, enable/disable the selected foreign key, or enable/disable all foreign keys. Using the menu you can also export the list of the table foreign keys to any of supported formats.


Foreign key management tools are also available through the Navigation bar of Table Editor.


Table Editor - Managing foreign keys


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

Foreign Key Name


Foreign Table

Foreign Columns

On Delete



For details see Foreign Keys.