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".