Space Manager with LiveReorg 9.0 - User Guide

View Constraints

View the Constraints tab in Object Properties to see a list of all integrity constraints defined for a table. This tab displays Primary Key, Unique, Foreign Key, Referencing Foreign Key, Not Null, and Check constraints.

The information displayed for each constraint includes deferrable state, status (enabled or disabled), and whether or not it is validated.

Constraints are grouped by type under type nodes. To collapse or expand a single type group, click - / + beside its node.

Note: The Constraints tab is not displayed for table partitions and subpartitions. To see the constraints used for these objects, select their parent table in the object tree. The constraints defined for a parent table are used for all of its partitions or subpartitions.

Constraint Fields

• Column Name—This field or table displays a list of all columns that define a constraint. If the column names are not visible, click + to expand the constraint name node.
• Foreign Key Constraint Fields—Information includes the name of the constraint referenced by a FOREIGN KEY, the table the constraint is on, the owner of the table, and the action defined for the referenced constraint.
• Referencing Foreign Key Constraint Fields—Information includes the name of the referencing table, the owner of the referencing table, and the action defined for the referenced constraint.
• Check Constraint Fields—Information consists of the check condition defined for the selected constraint.

View Dependencies

View the Dependencies tab in Object Properties to see a list of dependencies that reference a table. This tab displays triggers, procedures, views, materialized views, and packages.

The information displayed for each dependency includes dependency name, owner, type, and status. To see more information on triggers, view the Triggers tab.

View Dependency Trees

If a dependency is referenced by other dependencies, the dependencies are displayed in a hierarchical tree. This lets you see dependency relationships at a glance, saving the time it would take to trace dependencies that are many levels deep.

Dependencies that reference the selected table are displayed at the top level of the dependency tree. Dependencies that reference a table dependency descend from that dependency in the second level of the tree. Dependencies that reference second-level dependencies descend from them in the third level, and so on.

View Triggers

View the Triggers tab in Object Properties to see a list of the triggers defined for a table. The information displayed for each trigger includes trigger name, owner, trigger type, trigger firing event, and status.

To view the trigger description and the trigger body, select the trigger in the list. The description and body are displayed in the lower pane.

View DDL

Use the DDL tab of Object Properties to view the DDL statement for the selected object.

To view Object DDL statement

1. Right-click an object in the Explorer window and select Object Properties.
2. In the Object Properties window, select the DDL tab.
3. In the DDL tab, click Get DDL.