DB/Assist displays the following information about primary/foreign key relationships in the Primary Keys and Foreign Keys dialog boxes:

•Name of primary key or foreign key column

•Name of primary/foreign key relationship, as defined in DB2

•Name of child table (for a primary key) or name of parent table (for a foreign key)

To display primary/foreign key information for tables and views, follow these steps:

1.Open the Database Schema dialog box, as described in Examining Column Attributes.

2.Double-click on any one of the following:

•The name of a primary key column, indicated by PK in the Key column.
The Primary Keys dialog box for the selected column appears, as shown below.

Primary Keys Dialog Box

•The name of a foreign key column, indicated by FK in the Key column.
The Foreign Keys dialog box for the selected column appears, as shown below.

Foreign Keys Dialog Box

•The name of a column that is both a primary key and foreign key, indicated by PK/FK in the Key column.
 
The Foreign Keys dialog box for the selected column appears. The Primary Keys dialog box also appears if the table is a parent in a primary/foreign key relationship.
 
If the table is not a parent in any primary/foreign key relationship, a message box appears indicating this. Select the OK push button in the message box to see the Foreign Keys dialog box.

3. Select the Close push button or double-click on the system menu to close the dialog box.

If you double-click on a primary key column that has no child relationships defined, a message box appears indicating this.