Event Time

Description

Specifies the point of time when trigger conditions and actions are executed. The types of event time are BEFORE, AFTER and DEFERRED.

• BEFORE : Checks the condition before the event is processed.
• AFTER : Checks the condition after the event is processed.
• DEFERRED : Checks the condition at the end of the transaction for the event. If you specify DEFERRED, you cannot use COMMIT or ROLLBACK as the event type.