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.