Oracle / PLSQL: Disable all Triggers on a table

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 <strong>table_name</strong> 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.