Combination of Event Type and Target

Description

A database event calling triggers is identified by the trigger event type and event target in a trigger definition. The following table shows the trigger event type and target combinations, along with the meaning of the CUBRID database event that the trigger event represents.

Event Type

Event Target

Corresponding Database Activity

UPDATE

Table

Trigger is called when the UPDATE statement for a table is executed.

INSERT

Table

Trigger is called when the INSERT statement for a table is executed.

DELETE

Table

Trigger is called when the DELETE statement for a table is executed.

COMMIT

None

Trigger is called when database transaction is committed.

ROLLBACK

None

Trigger is called when database transaction is rolled back.