The ALTER TRIGGER statement is used to enable a trigger.
Syntax
ALTER TRIGGER trigger_name ENABLE;
trigger_name: It specifies the name of the trigger that you want to enable.
ALTER TRIGGER SUPPLIERS_T1 ENABLE;
This example will enable the trigger named "SUPPLIERS_T1" in the "SUPPLIERS" table.
Syntax
ALTER TABLE table_name ENABLE ALL TRIGGERS;
Example
ALTER TABLE SUPPLIERS ENABLE ALL TRIGGERS;
This example will enable all the triggers on the table name "SUPPLIERS".
