Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

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

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

Comments

comments