Disable all Triggers on a table
Course- Oracle/PLSQL >
This Oracle tutorial explains how to disable all triggers on a table in Oracle with syntax and examples.
Description
Once you have created Triggers in Oracle, you might find that you are required to disable all of the triggers on a table.. You can do this with the ALTER TRIGGER statement.
Syntax
The syntax for a disabling all Triggers on a table in Oracle/PLSQL is:
ALTER TABLE table_name DISABLE ALL TRIGGERS;
Parameters or Arguments
- table_name
- The name of the table that all triggers should be disabled on.
Note
- See also how to disable a trigger.
- See also how to enable a trigger on a table or enable all triggers on a table.
Example
Let's look at an example that shows how to disable all triggers on a table in Oracle.
For example:
ALTER TABLE orders DISABLE ALL TRIGGERS;
This example uses the ALTER TRIGGER statement to disable all triggers on the table called orders.