An ON statement can contain the single keyword REVERT to cancel an existing trigger definition before it goes out of scope:

ON events OF objects REVERT.

The REVERT statement cancels any run-time trigger for the event and object defined in the current procedure or trigger. Note that you cannot use REVERT to cancel a persistent trigger. Instead, you must run another persistent trigger procedure that either defines a new trigger or consists of just a RETURN statement.