DROP TRIGGER - Removes the definition of 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 trigger.

   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

   SQL92
       There is no DROP TRIGGER statement in SQL92.


Man(1) output converted with man2html