fastread homefastrread library fastread menu

Oracle/PLSQL : DROP TRIGGER Statement

Tutorial by:      Date: 2016-04-15 05:22:32

❰ Previous Next ❱

This Oracle tutorial explains how to use the DROP TRIGGER statement to drop a trigger in Oracle with syntax and examples.

Description

Once you have created a trigger in Oracle, you might find that you need to remove it from the database. You can do this with the DROP TRIGGER statement.

Syntax

The syntax to a drop a trigger in Oracle in Oracle/PLSQL is:

DROP TRIGGER trigger_name;

Parameters or Arguments

trigger_name

The name of the trigger that you wish to drop.

Note

  • See also how to create AFTER DELETE, AFTER INSERT, AFTER UPDATE, BEFORE DELETE, BEFORE INSERT, and BEFORE UPDATE triggers.

Example

Let's look at an example of how to drop a trigger in Oracle.

For example:

DROP TRIGGER orders_before_insert;

This example uses the ALTER TRIGGER statement to drop the trigger called orders_before_insert.

 

❰ Previous Next ❱


Oracle/PLSQL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website