drop_trigger man page on IRIX

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



     DROP TRIGGER(lSQL - Language Statements (2002-11-2DROP TRIGGER(l)

     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

     Page 1					     (printed 3/24/03)

     DROP TRIGGER(lSQL - Language Statements (2002-11-2DROP TRIGGER(l)

	  CREATE TRIGGER [create_trigger(l)]

     Page 2					     (printed 3/24/03)

[top]

List of man pages available for IRIX

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