DROP_TRIGGER(l)                                   DROP_TRIGGER(l)

NAME
       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.

SQL - Language Statements 15 August 1999                        1