Trigger Event

The trigger event specifies the data manipulation statement that will cause the trigger to execute. The possible values for the trigger event are: INSERT, UPDATE and DELETE.

The trigger will be executed once each time the specified data manipulation statement is executed on the table on which the trigger was created.

Note: If the trigger time is INSTEAD OF, the trigger event itself has no effect on the table, it just causes the trigger to execute. The environment executing the trigger event behaves as if the data manipulation statement is actually being executed, even though no changes actually occur in the table(s) that would normally be affected. The only data manipulations possible in this case are those performed by the trigger action.