Changing the Order of When a Trigger Is Fired

To change the order in which a trigger is fired, use the or replace option in the create trigger command, using the same trigger name, action, and trigger body as the original trigger, but specifying a new order number.