Foreign Keys Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Foreign Keys Editor lets you manage column mapping for a foreign key, modify update and delete rule actions, and specify a NOT ENFORCED value.

To edit a foreign key

  1. Open an editor on the foreign key. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Column Mapping

The existing column mapping for the foreign key is represented by selected columns in the Main Table and Referenced Table lists. Additional candidates in the Referenced Table list are indicated by enabled column check boxes. If necessary, use the Table dropdown in the Referenced Table group to choose a new table for this foreign key. Select or deselect columns in the Main Table list and Referenced Table list to form the referential constraint between the two tables.

Properties

Lets you modify the Delete Rule (NO ACTION, RESTRICT, CASCADE, SET NULL) and Update Rule (NO ACTION, RESTRICT) actions. This tab also lets you deselect the Enforced check box to specify a NOT ENFORCED option.

Comment

For details on using this tab, see Adding a Comment to an object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.