List Displays
- List of Tables/Views etc including Description
- List of Tables with Table Sizing
- List of Tables/Views etc with Create / Alter date
- List of Tables with Reorg Pending flag
- List of MDC tables, partitioned tables, column-organized tables
Details Display
- Columns
- Column sizing
- Table Details
- Primary Key Columns
- Unique Constraint Columns
- Indexes and Index Sizing
- Authorities on Table
- Views on Table
- Aliases on Table
- Packages using Table
- Compiled Routines using Table
- Other objects using Table
- Triggers on/using Table
- Referenced Tables (Foreign Keys)
- Dependent Tables
- Hash Partitioning Key
- Range Partitions and Partitioning Expressions
- MDC Dimensions
|
- Create / Alter / Drop / Redefine Table
- Create View / Summary Table on table
- Create Primary Key / Index / Unique Constraint on Table
- Create Foreign Key on Table
- Create Trigger on Table
- Create Check Constraint on Table
- Create Alias on Table
- Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases
- Administer Authorities for Table
- Compare tables definitions
- Manage table descriptions
- Manage column descriptions
- Rename table/s
- Rename columns
- Reset check pending on table/s
- Set integrity off for Tables
- Runstats on Table/s
- Reorg Table/s
- Activate not logged
- Delete contents of Table/s (truncate)
- Rebind dependent packages for Table
|