Display

Actions

List Displays

• List of Tables/Views
• List of Tables with Table Sizing
• List of Tables/Views with Date Created/Altered

Details Display

• Columns
• Column with Character Sets
• Table Status Statistics
• Primary Key Columns
• Indexes
• Unique Constraints
• Table Create Statement
• Authorities on Table
• Referenced Tables (Foreign Keys)
• Dependent Tables

• Create / Alter / Drop Table
• Create View on table
• Create Primary Key / Index on Table
• Create Foreign Key on Table
• Create Trigger on Table
• Generate DDL for Table and related indexes, keys
• Administer Authorities for Table
• Compare Tables definitions
• Rename table/s
• Rename columns
• Manage table descriptions
• Analyze table/s
• Optimize table/s
• Truncate table/s
• Enable / disable keys

Display

Actions

• Columns
• View Text

• Create / Drop View
• Generate DDL for View

Display

Actions

• Trigger Definition
• Trigger Details

• Create / Alter / Drop Trigger
• Generate DDL for Trigger
• Compare Trigger definition

Display

Actions

• Routine Definition
• Routine Details
• Authorities on Routine

• Create / Alter / Drop Routine
• Generate DDL for Routine
• Compare Routine definition
• Manage Authorities for Routine
• Manage Routine descriptions

Display

Actions

• Details of User
• Routine Details
• Table Authorities for User
• Procedure Authorities for User
• Function Authorities for User
• Show Grant Statements for User

• Create / Alter / Drop User
• Manage Table Authorities for User
• Manage Global Authorities for users
• Manage Database Authorities for users