DROP TRIGGER statement

Wed, 03/04/2009 - 20:02 |  hdanzl

Delete a trigger.


Syntax

<drop trigger statement> ::=

DROP TRIGGER [ IF EXISTS ] [ schema-name. ] trigger-name


Usage

The DROP TRIGGER statement deletes the trigger specified by trigger-name from the database.


Notes

♦ The current database is implicit if a schema name is not specified.
♦ The IF EXISTS clause can be specified to avoid an exception when attempting to delete a trigger that does not exist in the database.
♦ The DROP TRIGGER statement requires exclusive access to the subject table of the trigger definition.


Examples

1) The following example deletes the enrolls_changes trigger:

       DROP TRIGGER IF EXISTS enrolls_changes


Conformance

SQL:2003 standard

NexusDB extensions

-

-

-

Core SQL

Feature T211 "Basic trigger capability"

IF EXISTS clause
‹ DROP VIEW statementupDROP ROUTINE statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements

Powered by Drupal and Drupal Theme created with Artisteer.