Using DROP TRIGGER Statement in Oracle

This Oracle tutorial explains how to use the DROP TRIGGER assertion to drop a set off in Oracle with syntax and examples.

Description

Once you have created a trigger in Oracle, you would possibly discover that you want to put off 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 identify of the set off that you desire to drop.

Note

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

Example

Let’s seem to be at an example of how to drop a trigger in Oracle.

For example:

DROP TRIGGER orders_before_insert;

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