Parent Table variables are also available.
|
Variable |
Comment |
|---|---|
|
%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 |