drop_trigger man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

DROP TRIGGER()			 SQL Commands			DROP TRIGGER()

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 definiā€
       tion. 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	 29 March 2001			DROP TRIGGER()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net