15.00 - HELP TRIGGER - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

HELP TRIGGER

Trigger Attributes

 

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 “Working with Object Name and Title Data in HELP Reports” on page 896.

    Trigger SQL Name

    VARCHAR(644)

    No

    Trigger UEscape

    VARCHAR(1)

    Yes