17.10 - Defining Triggers for System-Time Tables - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

Triggers can be defined for INSERT, DELETE, and UPDATE operations on system-time tables. Note the following:

  • Actions are triggered only for actions on open rows, that is, rows that have not been logically deleted from the table.
  • Defined actions cannot reference the component beginning or ending bound TIMESTAMP columns of the SYSTEM_TIME derived period column.
  • The DELETE or UPDATE operation that triggers an action can be unqualified or can include the temporal FOR PORTION OF qualifier.
  • Trigger actions on ANSI temporal tables can be qualified with FOR PORTION OF.