17.10 - Defining Triggers for Valid-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 valid-time tables. Note the following restriction:

  • For BEFORE triggers, defined actions cannot reference the component beginning or ending bound DateTime columns of the valid-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.
  • Actions for DELETE and UPDATE triggers on ANSI temporal tables can be qualified with FOR PORTION OF.