Orcale SQL Tutorial

Drop Trigger

Oracle DROP Trigger

In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove it from the database.

Syntax

DROP TRIGGER trigger_name;

Parameters

trigger_name: It specifies the name of the trigger that you want to drop.

Oracle DROP Trigger Example

DROP TRIGGER SUPPLIERS_T1;

It will drop the trigger name "SUPPLIERS_T1" from the table "SUPPLIERS".