fastread homefastrread library fastread menu

Oracle/PLSQL : Disable all Triggers on a table

Tutorial by:      Date: 2016-04-15 05:23:18

❰ Previous Next ❱

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

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.

❰ Previous Next ❱


Oracle/PLSQL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website