You are here: Reference Information > SQL Reference Information > SQL Statements > DROP TRIGGER


DROP TRIGGER — remove a trigger


Dropping a Trigger at Schema Level

DROP TRIGGER [ IF EXISTS ] [schema.]trigger_name
DROP TRIGGER [schema.]trigger_name [ IF EXISTS ]

Dropping a Trigger at Database Level

DROP TRIGGER [ IF EXISTS ] trigger_name on database;
DROP TRIGGER trigger_name [IF EXISTS]on database;

Note that DDL triggers do not belong to any schema, so the schema prefix is not allowed.


Use the DROP TRIGGER statement to remove an existing trigger definition. The trigger must be in the current schema, or you must have the DROP ANY TRIGGER system privilege. To execute this command the current user must be the owner of the table for which the trigger is defined.