16.20 - Trigger - Teradata Database - Teradata Vantage NewSQL Engine

temporal_option

See Teradata Vantage™ Temporal Table Support , B035-1182 for documentation of these options.

INSERT

The triggering event for this trigger is one of the following:

• INSERT
• INSERT... SELECT
• Atomic Upsert
• MERGE

DELETE

The triggering event for this trigger is a DELETE.

UPDATE

The triggering statement for this trigger is one of the following:

• UPDATE
• Atomic Upsert
• MERGE

Any number of rows, including none, can be updated.

column_name

Name of a column in a set of column names.

The trigger fires when any column in the list is updated.

You can optionally enclose the list in parentheses.

If you do not specify a column name list, the default is all columns.

The list cannot specify duplicate column names.

The column_name list does not apply to INSERT or DELETE triggering events.