Removes a trigger definition from a database.
DROP TRIGGER name ON table
The name of the trigger you wish to remove.
The name of the table the trigger is on.
The message returned when a trigger is successfully dropped.
ERROR: DropTrigger: there is no trigger name on relation table
The error returned if the trigger
namedoes not exist on
DROP TRIGGER command to remove a trigger from the database.
All references to the trigger are removed when you issue this command. You must be the owner
of trigger in order to drop it.
The following command removes the
sync_authors_books trigger from the
authors table, in the
booktown=# DROP TRIGGER sync_authors_books ON authors; DROP