Use the Show Related notebook to relationships between tables, indexes,
views, aliases, triggers, tablespaces, UDFs, and UDTs.
Fields and controls
Authorities and privileges
To show the related objects:
- Open the Show Related notebook.
- Open the page you want related objects for by clicking on a tab.
Different related objects are listed depending on the tab you select.
(Only first level dependencies are shown in the 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, follow the next step.)
- Optional. Click mouse button 2 on a related object on the selected
Page and select Show Related from the pop-up menu. The selected Page
changes to show the objects related to your latest selection. Your
previous target object is added to the list.
- Optional. If you want to compare the relationships between multiple
target objects and their related objects, you can Open
the Show Related notebook multiple times from the Control Center object
tree.
- Optional. Click on the down arrow next to the Target object to display a list of previously
selected target objects and select one. The selected Page changes to
show the related objects.
- Optional. Click on Show SQL to
view and save the SQL query that defines the relationships between
objects.
- Click on Close to close the Show Related
notebook and return to the Control Center.
Inspecting a target object presents a different set of tabs:
| Target Object
| Related Object
|
| Table
| Aliases, Indexes, Tables, Table Spaces, Views, Triggers, UDTs, UDFs
|
| View
| Aliases, Tables, Views, Triggers, UDFs
|
| Alias
| Aliases, Tables, Views, Triggers
|
| Trigger
| Aliases, Tables, Views, UDFs
|
| Index
| Tables, Table Spaces
|
| Table Space
| Tables, Indexes
|
| UDT
| Table, UDF
|
| UDF
| Triggers, UDTs, UDFs,
|
Related information