ALTER TRIGGER

The ALTER TRIGGER statement is used to enable/disable trigger.

ALTER TRIGGER trigger_name
    { ENABLE | DISABLE }

ALTER TRIGGER switch_t1_t2 DISABLE