Time (Trigger Keyword)
Specifies whether the trigger is fired before or after the event.
Usage
To specify whether the trigger is fired before or after the event, use the following syntax:
Trigger name [ Event = sqlevent, Time = time ] { //implementation }
Where time is one of the following:
-
AFTER — this trigger is fired after an event.
-
BEFORE — this trigger is fired before an event.
Details
This keyword specifies whether the trigger is fired before or after the event.
Default
The default value is BEFORE.
