15.00 - 15.10 - When to Fire Triggers - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

You can specify when triggers fire.

 

WHEN you specify…

THEN the triggered action…

BEFORE

executes before the completion of the triggering event.

As specified in the ANSI/ISO SQL standard, a BEFORE trigger cannot have data changing statements in the triggered action.

AFTER

executes after completion of the triggering event.

Note: To support stored procedures the CALL statement is supported in the body of an AFTER trigger. Both row and statement triggers can call a stored procedure.

Sometimes a request fires a trigger, which in turn, fires another trigger. Thus the outcome of one triggering event can itself become another trigger. Teradata Database processes and optimizes the triggered and triggering statements in parallel to maximize system performance.