|Name||VARCHAR(30)||No||The name of the trigger.|
|Actiontime||CHAR(1)||No||When the trigger fires.
For triggers created in prior releases of Teradata Database with INSTEAD OF as the action time, the code I is displayed. Such triggers are not valid.
|Decimal Order Value||INTEGER||No||The optional integer value used to specify the order in which the trigger fires, when multiple triggers are defined on the same table.
This value overrides the ANSI-specified default order of execution.
If no ORDER value has been specified with the trigger, the default value of 32,767 is displayed.
|Creation Timestamp||TIMESTAMP(0)||No||When the trigger was first created, or when its timestamp was last altered using the ALTER TRIGGER … TIMESTAMP statement.|
|Event||CHAR(1)||No||The triggering event, that is, the SQL DML statement type that causes the trigger to fire.
|Kind||CHAR(1)||No||The trigger type as defined by the FOR EACH clause.
|Enabled||CHAR(1)||No||Whether the trigger is activated or not.
|Comment||VARCHAR(255)||Yes||Optional text commenting on the named trigger.
This attribute can be null.
|Trigger Dictionary Name||VARCHAR(128)||No||The attributes shown in this section are based upon and supersede the corresponding older Name attribute, while providing additional functionality.
The older attribute is retained for compatibility with existing applications.
For details, see the topics beginning with Object Name and Title Data in HELP Reports.
|Trigger SQL Name||VARCHAR(644)||No|