In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove it from the database.
- DROP TRIGGER trigger_name;
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”.