Show Related -- Overview

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

Only first level dependencies are shown in the table. 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, click mouse button 2 on the view related object and select Show Related from 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. These include:

• You want to know the structure of the database.

• You want to drop or recreate an object and need to know all the dependency relationships on the object to be dropped or created. Dropping an object that has a dependency may present problems. For example, if you drop a table with dependent views they will be marked inoperative.

To see the SQL query that defines the relationships between objects, click on the Show SQL push button.

Tasks

• Showing related objects

Fields and controls

• Target Object
• Show SQL
• Close

Related information

• Altering a database - See the Administration Guide
• Creating a database - See the Administration Guide