Index for Section TRIGGER

Alphabetical listing for D

Bottom of page

DROP
NAME
  DROP TRIGGER - remove a trigger

SYNOPSIS
  DROP TRIGGER name ON table [ CASCADE | RESTRICT ]

  INPUTS

  name The name of an existing trigger.

  table
       The name (optionally schema-qualified) of a table.

  CASCADE
       Automatically drop objects that depend on the trigger.

  RESTRICT
       Refuse to drop the trigger if there are any dependent objects.  This
       is the default.

  OUTPUTS

  DROP TRIGGER
       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 an existing trigger definition. To execute this
  command the current user must be the owner of the table for which the
  trigger is defined.

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

  SQL99
       The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99.
       In SQL99, trigger names are not local to tables, so the command is
       simply DROP TRIGGER name.

SEE ALSO
  CREATE TRIGGER [create_trigger(5)]

Index for Section TRIGGER

Alphabetical listing for D

Top of page