—
NAME
DROP_TRIGGER - remove a trigger
SYNOPSIS
bash
DROP TRIGGER [ IF EXISTS ] \nname\n ON \ntable_name\n [ CASCADE | RESTRICT ]DESCRIPTION
DROP TRIGGER removes an existing trigger definition. To execute this command, the current user must be the owner of the table for which the trigger is defined.
PARAMETERS
IF EXISTS
name
table_name
CASCADE
RESTRICT
EXAMPLES
Destroy the trigger if_dist_exists on the table films:
bash
DROP TRIGGER if_dist_exists ON films;COMPATIBILITY
The DROP TRIGGER statement in PostgreSQL is incompatible with the SQL standard. In the SQL standard, trigger names are not local to tables, so the command is simply DROP TRIGGER name.
SEE ALSO
CREATE TRIGGER (CREATE_TRIGGER(7))