Object documentationTRIGGERS Locate this document in the navigation structure

 

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

Structure

TRIGGERS

SCHEMANAME

CHAR(32)

Name of the table schema

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

Creation date of the trigger

CREATETIME

TIME

Creation time of the trigger

DEFINITION

CLOB

Trigger definition text

COMMENT

CLOB

Comments on the trigger

More Information

Evaluating System Tables, TRIGGERS

SQL Reference Manual, Trigger Name (trigger_name)