Online Documentation for SQL Manager for DB2

Foreign keys


The Foreign Key tab is provided for managing table Foreign keys. Double-click a 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, view, 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.

 

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

 

Table Editor - Constraints - Foreign keys

 

 

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

Key Name

Field Names

Foreign Table Names

Foreign Field Names

Delete Rule

Update Rule

Comment

 

For details see Foreign keys.