Display

Actions

List Displays

• List of Tables/Views
• List of Tables/Views with Description
• List of Tables with Table Sizing
• List of Tables with TOAST table

Details Display

• Columns
• Column Extended Info
• Column Statistics
• Table Statistics
• Table IO statistics
• Primary Key Columns
• Indexes
• Check Constraints
• Authorities on Table
• Views on Table
• Triggers
• Referenced Tables (Foreign Keys)
• Dependent Tables
• Table Partitions
• Tables inherited from (parents)
• Inheriting tables (children)

• Create / Alter / Drop Table
• Create View on table
• Create Primary Key / Index on Table
• Create Foreign Key on Table
• Create Trigger on Table
• Create Check Constraint on Table
• Generate DDL for Table and related indexes, keys, views, triggers, constraints
• Compare Tables comments
• Manage table comments
• Manage column comments
• Rename table/s
• Rename columns
• Analyze Table/s
• Truncate Table/s
• Cluster table/s
• Enable / Disable Triggers
• Move to new Tablespace
• Vacuum Table/s
• Reindex Table/s

Display

Actions

• Columns
• View Definition
• Objects referenced by View
• Views on View
• Authorities on View

• Create / Alter / Drop View
• Generate DDL for View
• Compare View definitions
• Manage View comments
• Manage column comments
• Rename columns

Display

Actions

• Columns
• Definition of Materialized View
• Indexes
• Views on Materialized View
• Objects referenced by Materialized View
• Views on Materialized View
• Authorities on Materialized View

• Create / Alter / Drop Materialized View
• Generate DDL for Materialized View
• Manage Materialized View comments
• Manage column comments
• Rename Materialized View/s
• Rename columns
• Analyze Materialized View/s
• Cluster Materialized View/s
• Move to new Tablespace
• Vacuum Materialized View/s
• Reindex Materialized View/s
• Refresh Materialized View

Display

Actions

• Index Text
• Index Statistics

• Create / Drop Index
• Generate DDL for Index
• Manage Index comments
• Rename index
• Move to new tablespace
• Reindex Index

Display

Actions

• Tablespace details including Location
• Tables in Tablespace (with sizing)
• Indexes in Tablespace (with sizing)

• Create Tablespace

Display

Actions

• Detail of User/Role
• Members of Role
• Roles this user/role belongs to
• Table Authorities
• Routine Authorities
• Usage Authorities

Display

Actions

List Displays

• List of User Triggers
• List of User Triggers with Descriptions
• List of Disabled Triggers
• List of All Triggers
• List of All Triggers with Events

Details Display

• Trigger Details
• Trigger Function Text

• Create / Redefine / Drop Trigger
• Compare Trigger definitions
• Manage Trigger comments
• Enable / Disable Trigger/s

Display

Actions

• Routine Text
• Routine Parameters
• Details of Routine
• Authorities on Routine

• Create / Redefine / Drop Routine
• Generate DDL for Routine
• Compare Routine definitions
• Manage Function comments

Display

Actions

• Details of Sequence
• Columns using Sequence

• Create / Alter / Drop Sequence
• Generate DDL for Sequence