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.
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.
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 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.
Use the DDL tab of Object Properties to view the DDL statement for the selected object.
To view Object DDL statement
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz