TRIGGERS

Definition

The system table TRIGGERS contains all the triggers for which the current user has privileges.

Structure

TRIGGERS

SCHEMANAME

CHAR(32)

Name of the schema of the table

OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Name of the table for which the trigger was defined

TRIGGERNAME

CHAR(32)

Name of the trigger

INSERT

CHAR(3)

Trigger is executed after an INSERT statement (YES | NO)

UPDATE

CHAR(3)

Trigger is executed after an UPDATE statement (YES | NO)

DELETE

CHAR(3)

Trigger is executed after an DELETE statement (YES | NO)

CREATEDATE

DATE(10)

Creation date of the trigger

CREATETIME

TIME(8)

Creation time of the trigger

DEFINITION

LONG

Trigger definition text

COMMENT

LONG

Comments on the trigger

See also:

Evaluating System Tables, TRIGGERS

SQL Reference Manual, Trigger Name (trigger_name)