Online Documentation for SQL Manager for PostgreSQL

Managing foreign keys


The Foreign Keys tab is provided for managing table foreign keys. Double-click a foreign key to open 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 a foreign key. Using the menu you can also export the list of the table foreign keys to any of supported formats.

 

Foreign keys management tools are also available through the Navigation bar and toolbar 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

On Field

FK Table

FK Field

On Update

On Delete

Deferrable

Check Time

Description

 

For details see Foreign Keys.

 

If necessary, you can also use the Foreign Key Description area to supply a description for each foreign key.