v2025.1 STS Stable release with standard-term support v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support Unsupported versions

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