DROP TRIGGER

This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

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