Defining Triggers for Valid-Time Tables - Teradata Database

SQL External Routine Programming

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata® Database

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.