DROP TRIGGER

Synopsis

Use the DROP TRIGGER statement to remove a trigger from the database.

Syntax

drop_trigger ::= DROP TRIGGER [ IF EXISTS ] name ON table_name 
                 [ CASCADE | RESTRICT ]

drop_trigger

DROPTRIGGERIFEXISTSnameONtable_nameCASCADERESTRICT

Semantics

  • RESTRICT is the default and it will throw an error if any objects depend on the trigger.
  • CASCADE will drop all objects that (transitively) depend on the trigger.

Examples

DROP TRIGGER update_moddatetime ON posts;

See also