DISABLE ENABLE and DROP TRIGGERS – Learn how to disable and enable trigger on a table with examples. Also Learn how to remove a triggers from database using DROP Triggers.
Disable a Trigger
If we don’t want to fire a trigger on a table then we want to disable that trigger.
Syntax
ALTER TRIGGER trigger_name DISABLE;Example
ALTER TRIGGER DISP_NEW_EMP_DATA DISABLE;This example uses the ALTER TRIGGER statement to disable the trigger called DISP_NEW_EMP_DATA .
Disable all Triggers
If we don’t want to fire all triggers that created on a table, then we want to disable all the triggers.
Here the syntax to disable all the triggers on a table at once
Syntax
ALTER TABLE table_name DISABLE ALL TRIGGERS;Example
ALTER TABLE EMP1 DISABLE ALL TRIGGERS;This example uses the ALTER TRIGGER statement to disable all triggers on the table called EMP
Enable a Trigger
If you find the trigger on a table is disabled and now you want to enable the trigger,Then we can do with the alter statement.
Syntax
ALTER TRIGGER trigger_name ENABLE;Example
ALTER TRIGGER DISP_NEW_EMP_DATA ENABLE;This example uses the ALTER TRIGGER statement to enable the trigger called DISP_NEW_EMP_DATA.
Enable all Triggers
If you find that all the triggers on a table is disabled , if you want to enable all the triggers on a table then we can do all with alter statement.
Here is the syntax to enable all the triggers on a table.
Syntax
ALTER TABLE table_name ENABLE ALL TRIGGERS;Example
ALTER TABLE EMP ENABLE ALL TRIGGERS;This example uses the ALTER TABLE statement to enable all triggers on the table called EMP .
DROP TRIGGER
If you want to remove a trigger on a table from a database, then we can drop the triggers with DROP statement.
Syntax
DROP TRIGGER trigger_name;Example
DROP TRIGGER DISP_NEW_EMP_DATA;