16.20 - Trigger Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
Attribute Data Type NULLABLE? Description
Name VARCHAR(30) No The name of the trigger.
Actiontime CHAR(1) No When the trigger fires.
  • A indicates that the trigger fires after the execution of the triggering statement.
  • B indicates that the trigger fires before the triggering statement.

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.
  • D represents DELETE.
  • I represents INSERT, including INSERT... SELECT, Atomic Upsert, and MERGE inserts.
  • U represents UPDATE, including Atomic Upsert, and MERGE updates.
Kind CHAR(1) No The trigger type as defined by the FOR EACH clause.
  • R is a row trigger.
  • S is a statement trigger.
Enabled CHAR(1) No Whether the trigger is activated or not.
  • N specifies that the trigger is disabled.
  • Y specifies that the trigger is enabled.
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
Trigger UEscape VARCHAR(1) Yes