DROP TRIGGER

DROP TRIGGER — remove a trigger

Syntax

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.

Description

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.

Parameters

Examples