Name
DROP TRIGGER
-- Removes the definition of a trigger from a database.
Synopsis
DROP TRIGGER name ON table
Parameters
- name
This parameter takes the name of an existing trigger you wish to remove.
- table
This parameter takes the name of a table the trigger is on.
Results
- DROP
This message is displayed if the trigger specified is successfully dropped.
- ERROR: DropTrigger: there is no trigger name on relation "table"
This error is displayed if the trigger specified does not exist.
Description
Use the DROP TRIGGER command to remove a trigger from the database.
All references to the definition are removed when you issue this command. You must be the owner
of the specified trigger to drop it.
Examples
The following example removes the if_author_added trigger
from the author table.
DROP TRIGGER if_author_added ON author;