Variables for Triggers

%ORDER%

Order number of Trigger (in case DBMS support more than one trigger of one type)

%TRIGGER%

Generated code of trigger

%TRGTYPE%

Trigger type. It contains Keywords "beforeinsert", "afterupdate", ...etc.

%TRGEVENT%

Trigger event. It contains Keywords "insert", "update", "delete"

%TRGTIME%

Trigger time. It contains Keywords NULL, "before", "after"

%REFNO%

Reference order number in List of references of Table

%ERRNO%

Error number for standard error

%ERRMSG%

Error message for standard error

%MSGTAB%

Name of Table containing user-defined error messages

%MSGNO%

Name of Column containing Error numbers in User-defined error table

%MSGTXT%

Name of Column containing Error messages in User-defined error table

%SCRIPT%

SQL script of trigger or procedure.

%TRGBODY%

Trigger body (only for Oracle live database reverse engineering)

%TRGDESC%

Trigger description (only for Oracle live database reverse engineering)

%TRGDEFN%

Trigger definition