Actions of Multiple Triggers

When an UPDATE or MERGE statement activates multiple triggers, the trigger actions merge. Assume that taba has columns a, b, c, and d, as this example shows: 
CREATE TABLE taba (a INT, b INT, c INT, d INT);
Next, assume that you define trig1 on columns a and c, and trig2 on columns b and d. If both triggers specify BEFORE, FOR EACH ROW, and AFTER actions, then the trigger actions are executed in the following order:
  1. BEFORE action list for trigger (a, c)
  2. BEFORE action list for trigger (b, d)
  3. FOR EACH ROW action list for trigger (a, c)
  4. FOR EACH ROW action list for trigger (b, d)
  5. AFTER action list for trigger (a, c)
  6. AFTER action list for trigger (b, d)

The database server treats all the triggers that are activated by the same triggering statement as a single trigger, and the trigger action is the merged-action list. All the rules that govern a trigger action apply to the merged list as one list, and no distinction is made between the two original triggers.