Switch to: V9V8V7V6V5

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;