· Schema comment definition
· Privilege information (only when -p is specified)
· Names of tables belonging to the schema
· Table type (base, view, or temporary table)
· Names of routines belonging to a schema
· Types of routines belonging to a schema
· Names of triggers belonging to a schema
· Names of sequences belonging to a schema
TABLE specification
· Table, view table, or temporary table name
· Name of database to which the table belongs
· Name of schema to which the table belongs
· Type (base, view, or temporary table)
· Base, view, or temporary table creator
· Table definition date and time and update date and time
· Table comment definition
· Privilege information (only when -p is specified)
· Column information (column name, existence of NOT NULL specification, byte length, data type, DE FAULT
value)
· Table record length
· Table constraint information (PRIMARY KEY information and UNIQUE information)
· PRIMARY KEY information (component column names)
· UNIQUE information (component column names)
· Table DSO name
· Index DSO name
· Routine name
· Routine type
· View information (reference view information, configuration view information, query expression, indic ation of
whether WITH CHECK OPTION is specified, updatability)
· Trigger name
· Name of the database space to which a temporary table is allocated
· Number of users of the database space to which a temporary table is allocated
TRIGGER specification
· Trigger name
· Name of database to which the trigger belongs
· Name of schema to which the trigger belongs
· Trigger creator
· Trigger definition date and time
· Name of schema to which the trigger-target table belongs
· Name of trigger-target table
· Type of trigger-target table
· Trigger operation point
· Trigger event
· Name of column to be updated in the trigger-target table
· Correlation name of old and new values in the trigger-target table.
· Execution unit of triggered operation
· Execution condition of triggered operation
· Table name included in the SQL statement of triggered operation
· Name of schema to which the table included in the SQL statement of the triggered operation belongs
· Type of table included in the SQL statement of triggered operation
· SQL statement of triggered operation
· Routine name included in the SQL statement of a triggered operation
· Name of the schema to which the routine included in the SQL statement of a triggered operation belongs
· Type of routine included in the SQL statement of a triggered operation
· Sequence name included in the SQL statement of a triggered operation
· Name of the schema to which a sequence included in the SQL statement of a triggered operation belongs
Routine specification
· Routine name
· Name of the database to which a routine belongs
· Name of the schema to which a routine belongs
· Routine creator
89