Introduction to CUBRID Manual 
CUBRID SQL Guide 
Guideline for TRIGGER Definition Versions available for this page: CUBRID 8.3.0 | CUBRID 8.3.1 | CUBRID 8.4.0 | CUBRID 8.4.1 |
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 whenever any column of the table is updated. |
|
STATEMENT UPDATE |
Table |
Trigger is called whenever an UPDATE statement is executed on the table. |
|
INSERT |
Table |
Trigger is called whenever an instance of the table is created. |
|
STATEMENT INSERT |
Table |
Trigger is called whenever an INSERT statement is executed on the table. |
|
DELETE |
Table |
Trigger is called whenever an instance of the table is deleted. |
|
STATEMENT DELETE |
Table |
Trigger is called whenever a DELETE statement is executed on the table. |
|
COMMIT |
None |
Trigger is called whenever a database transaction is committed. The COMMIT WORK statement initiates this trigger. |
|
ROLLBACK |
None |
Trigger is called whenever the database transaction is rolled back. The ROLLBACK WORK statement initiates this trigger. |