Showing related objects - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Show Related notebook to show the relationships between tables, indexes, views, aliases, triggers, table spaces, UDFs, and UDTs.

About this task

Only first-level dependencies are shown in the table in the Show Related notebook. For example, if you select a table as the target object and the table has a dependency on a view which also has a dependency on another view, only the table dependency is shown. To see the dependency on the view, right-click the view-related object and click Show Related in the pop-up menu.

If you want to compare the relationships between several target objects and their related objects, you can open several Show Related notebooks from the Control Center object tree.

There are several reasons to show related objects, including:

To see the structure of the database.
To drop or recreate an object, which requires identifying all of the dependency relationships on the object to be dropped or created. Dropping or recreating an object that has one or more dependencies might present problems. For example, if you drop a table with dependent views, the views will be marked inoperative.

Procedure

To see the SQL query that defines the relationships between objects, click Show SQL.
To open the Show Related notebook:
1. From the Control Center, expand the object tree until you find the object you want to work with such as a table, index, view, alias, trigger, table space, UDF, or UDT.
2. Right click the object, and click Show Related from the pop-up menu. The Show Related window opens.
3. Optional. Repeat the above steps to open another Show Related notebook. You can open multiple Show Related notebooks to show related objects.
To open another view in the Show Related notebook: From each page of the Show Related notebook, right click the object for which you want to view related objects, and click Show Related in the pop-up menu. The Target object changes to the object you just selected. The Show Related notebook page changes to show the objects related to your latest selection. Your previous target object is added to the list.

What to do next

You can perform other actions in the Show Related notebook by right-clicking the object in the Show Related notebook and clicking an action in the pop-up menu.