Table of Contents
DROP TRIGGER
Syntax
drop_trigger_statement
: DROP TRIGGER [IF EXISTS] trigger_name
Arguments
trigger_name
The name of the trigger to remove.
IF EXISTS
Do not raise error in case there is no trigger with the specified name.
Possible Errors
* “Trigger with name %U is not found.”
You can use IF EXISTS to force command do not report this error.
Examples
Destroy the trigger if_dist_exists on the table films:
DROP TRIGGER if_dist_exists ON films;