DROP TRIGGER

Synopsis

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

Syntax

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

drop_trigger

DROP TRIGGER - 图1

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

  1. DROP TRIGGER update_moddatetime ON posts;

See also