DROP TRIGGER Statement

statement_DROP_TRIGGER ::= DROP [ IF EXISTS ] TRIGGER [scheme.]trigger_name;

The DROP TRIGGER statement deletes a trigger with the specified name. The trigger will remain functional in previous prepared SQL statements after it has been deleted.

If the trigger of the specified name does not exist in the schema, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

You can also delete a trigger from the control panel of the 602SQL Client.

See

CREATE TRIGGER
ALTER TRIGGER

ALTER TRIGGER Statement

Triggers

Trigger Efficiency