16.20 - FOR EACH - Teradata Database - Teradata Vantage NewSQL Engine

Keywords specifying when the trigger is to fire.

ROW

The trigger is to fire for each qualified row. That is, each row that evaluates to TRUE for any WHEN condition specified for the trigger.

FOR EACH STATEMENT is the default.

STATEMENT

The trigger is to fire once per processed SQL statement in the request whenever a WHEN condition for the trigger evaluates to TRUE.

FOR EACH STATEMENT is the default.