Event (Trigger Keyword)

Specifies the SQL events that will fire this trigger. Required (no default).

Usage

To specify the SQL events that will fire the trigger, use the following syntax:

Trigger name [ Event = sqlevent, Time = AFTER ] {    //implementation }

Where sqlevent is one of the following values:

DELETE — this trigger is fired during an SQL DELETE operation.
INSERT — this trigger is fired during an SQL INSERT operation.
UPDATE — this trigger is fired during an SQL UPDATE operation.
INSERT/UPDATE — this trigger is fired during an SQL Insert operation or an SQL UPDATE operation.
INSERT/DELETE — this trigger is fired during an SQL Insert operation or an SQL DELETE operation.
UPDATE/DELETE — this trigger is fired during an SQL Update operation or an SQL DELETE operation.
INSERT/UPDATE/DELETE — this trigger is fired during an SQL INSERT operation, an SQL UPDATE operation, or an SQL DELETE operation.

This keyword specifies the SQL events that will fire the trigger.

There is no default. When you define a trigger, you must specify a value for this keyword.