DROP TRIGGER

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;