Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for drop_trigger (redhat section 7)

DROP TRIGGER(7) 			   SQL Commands 			  DROP TRIGGER(7)

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  cur-
       rent 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(7)]

SQL - Language Statements		    2002-11-22				  DROP TRIGGER(7)


All times are GMT -4. The time now is 11:54 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password