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.