This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
DROP
TRIGGER
Name
DROP TRIGGER -- remove a trigger
Synopsis
DROP TRIGGER name ON table
Inputs
- name
-
The name of an existing trigger.
- table
-
The name of a table.
Outputs
- DROP
-
The message returned if the trigger is successfully
dropped.
- ERROR: DropTrigger: there
is no trigger name on
relation "table"
-
This message occurs if the trigger specified does not
exist.
Description
DROP TRIGGER will remove all references
to an existing trigger definition. To execute this command the
current user must be the owner of the table for which the trigger
is defined.
Examples
Destroy the if_dist_exists trigger on
table films:
DROP TRIGGER if_dist_exists ON films;
Compatibility
- SQL92
-
There is no DROP TRIGGER
statement in SQL92.
- SQL99
-
The DROP TRIGGER statement in
PostgreSQL is incompatible
with SQL99. In SQL99, trigger names are not local to
tables, so the command is simply DROP
TRIGGER name.