EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Managing foreign keys

The Foreign Keys tab is provided for managing view foreign keys. Note that the tab is only available when you edit an existing view.


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 view foreign keys to any of supported formats.


View Editor - Managing foreign keys


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

Foreign Key Name


Foreign Table

Foreign Columns



For details see Foreign Keys.