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:-
Parameters:-
trigger_name:- It specifies the name of the trigger that you want to drop.
Oracle DROP Trigger Example
It will drop the trigger name "SUPPLIERS_T1" from the table "SUPPLIERS".
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".