DROP TRIGGER [IF EXISTS] [
This statement drops a trigger. The schema (database) name is optional. If the schema is omitted, the trigger is
dropped from the default schema.
TRIGGER requires the
privilege for the table associated with the trigger.
IF EXISTS to prevent an error from occurring for a trigger that does not exist.
NOTE is generated for a nonexistent trigger when using
EXISTS. See Section 184.108.40.206, "
Triggers for a table are also dropped if you drop the table.