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

Teradata Vantageā„¢ - ANSI Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.