Oracle DROP Trigger

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

Syntax

  1. DROP TRIGGER trigger_name;   

Parameters

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

Oracle DROP Trigger Example

  1. DROP TRIGGER SUPPLIERS_T1;   

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