7:drop trigger

From Linux Man Pages

      DROP TRIGGER - remove a trigger
      
      DROP TRIGGER name ON table [ CASCADE | RESTRICT ]

Contents 1 DESCRIPTION 2 PARAMETERS 3 EXAMPLES 4 COMPATIBILITY 5 RELATED 6 CATEGORY

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.

PARAMETERS

      name   The name of the trigger to remove.
 
      table  The name (optionally schema-qualified) of the table for which the trigger is defined.
 
      CASCADE
             Automatically drop objects that depend on the trigger.
 
      RESTRICT
             Refuse to drop the trigger if any objects depend on it. This is the default.

EXAMPLES

      Destroy the trigger if_dist_exists on the table films:
 
      DROP TRIGGER if_dist_exists ON films;

COMPATIBILITY

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

RELATED

      CREATE TRIGGER [[[7:create_trigger|create_trigger(7)]]]

SQL - Language Statements 2005-11-05 DROP TRIGGER()

CATEGORY