SYSTEMTRIGGERS

Definition

The system table SYSTEMTRIGGERS contains all system triggers that the current user has created.

Structure

SYSTEMTRIGGERS

SCHEMANAME

CHAR(32)

Name of the schema of the system trigger

TRIGGERNAME

CHAR(32)

Name of the system trigger

OWNER

CHAR(32)

Name of the owner of the system trigger

CREATEDATE

DATE(10)

Creation date of the system trigger

CREATETIME

TIME(8)

Creation time of the system trigger

DEFINITION

LONG

SQL statement for creating the system trigger

COMMENT

LONG

Comment for the system trigger

See also:

SQL Reference Manual, CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement)