16.20 - Trigger - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.