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. |