Skip to main content

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.

Details

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

Default

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

See Also

FeedbackOpens in a new tab