NexusDB V3 Manual
DROP TRIGGER statement
|
|
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.