Previous Topic

Next Topic

Book Contents

Book Index

DB2 for i

The Database Explorer window provides the following support for DB2 for i objects.

Tables

Display

Actions

List Displays

  • List of all Objects (Tables, Views, Aliases, Physicals, Logicals)
  • List of Objects with Comments
  • List of Objects with System table Name

Details Display

  • Columns
  • Columns with System Names
  • Primary Key
  • Indexes
  • Check Constraints
  • All Constraints
  • Views on Table
  • Aliases on Table
  • Triggers on Table
  • Triggers involving Table
  • Referenced Tables (foreign keys)
  • Dependent Tables
  • Create / Alter / Drop / Redefine Table
  • Create View 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
  • Compare Tables definitions
  • Manage Table Descriptions
  • Manage Table Comments
  • Manage column Descriptions
  • Manage column Comments
  • Manage column Headings
  • Rename table/s

Views

Display

Actions

  • Columns
  • Columns with System Names
  • View Definition
  • Views on View
  • Objects in View
  • Aliases on View
  • Triggers on View
  • Create / Drop / Redefine View
  • Generate DDL for View
  • Compare View definitions
  • Manage View Descriptions
  • Manage View Comments
  • Manage column Comments

Aliases

Display

Actions

  • Columns
  • Columns with System Names
  • Full Details of Alias
  • Views on Alias
  • Create / Drop Alias
  • Generate DDL for Alias
  • Manage Alias Descriptions

Physicals

Display

Actions

  • Columns
  • Columns with System Names
  • Key Fields
  • Indexes
  • Check Constraints
  • All Constraints
  • Views on File
  • Aliases on File
  • Files Dependent on this
  • Files this Depends on
  • Triggers on File
  • Triggers involving File
  •  

Logicals

Display

Actions

  • Columns
  • Columns with System Names
  • Views on File
  • Objects in File
  • Aliases on File
  • Files Dependent on this
  • Files this Depends on
  •  

Packages

Display

Actions

  • Package Detail
  • Rebind / Drop Package
  • Manage Package Comments

Indexes

Display

Actions

  • Columns
  • Columns with Description
  • Indexed Table
  • Index Details
  • Create / Drop Index
  • Create Primary Key
  • Generate DDL for Index
  • Manage Index Comments

Routines (Procedures and Functions)

Display

Actions

  • Routine Parameters
  • Result Columns
  • Routine Detail
  • Routine Text
  • Create / Alter / Drop Routine
  • Create External and SQL Routine
  • Compare Routines
  • Manage Routine Comments

Triggers

Display

Actions

  • Trigger Detail
  • Trigger Text
  • Referenced Columns
  • Dependent Objects
  • Update-trigger columns
  • Create / Redefine / Drop Trigger
  • Generate DDL for Trigger
  • Compare Triggers
  • Manage Trigger Descriptions

Sequences

Display

Actions

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