Delete a trigger.


<drop trigger statement> ::=

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


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


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.


1) The following example deletes the enrolls_changes trigger:

       DROP TRIGGER IF EXISTS enrolls_changes


SQL:2003 standard

NexusDB extensions




Core SQL

Feature T211 "Basic trigger capability"

IF EXISTS clause

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements