The ALTER TRIGGER statement is used to disable a trigger.
Syntax
ALTER TRIGGER trigger_name DISABLE;
trigger_name: It specifies the name of the trigger that you want to disable.
ALTER TRIGGER SUPPLIERS_T2 DISABLE;
This example will disable the trigger called "SUPPLIERS_T2" from the table "SUPPLIERS".
If there is more than one trigger in a table and you want to disable all the triggers from the database then you can do it by ALTER TABLE statement.
Syntax
ALTER TABLE table_name DISABLE ALL TRIGGERS;
Example
ALTER TABLE SUPPLIERS DISABLE ALL TRIGGERS;
This example will disable all triggers from the table "suppliers".
