DROP TRIGGER
SQL - Language Statements
DROP TRIGGER
Removes the definition of a trigger
1998-09-22
DROP TRIGGER name ON table
1998-09-22
Inputs
name
The name of an existing trigger.
table
The name of a table.
1998-09-22
Outputs
status
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.
1998-09-22
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 trigger.
1998-09-22
Notes
DROP TRIGGER is a Postgres
language extension.
Refer to CREATE TRIGGER for
information on how to create triggers.
Usage
Destroy the if_dist_exists trigger
on table films:
DROP TRIGGER if_dist_exists ON films;
Compatibility
1998-09-22
SQL92
There is no DROP TRIGGER statement in
SQL92.