Home > APIs > YSQL > The SQL language > SQL statements >

DROP TRIGGER

Synopsis

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

Syntax

Grammar
Diagram

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

drop_trigger

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