Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Schema Statements >

DROP TRIGGER statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

DROP TRIGGER statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Schema Statements

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

 

© Nexus Database Systems Pty Ltd.

nexus_logo