Background documentationDROP TRIGGER Statement (drop_trigger_statement) Locate this document in the navigation structure


The DROP TRIGGER statement (drop_trigger_statement) deletes a trigger from a table.


Syntax Syntax

  1. <drop_trigger_statement> ::=
      DROP TRIGGER <trigger_name> OF <table_name>
End of the code.

SQL Tutorial, Database Triggers


If a schema is not specified in the table name, the current schema is accepted implicitly.

The table name must identify an existing table in the schema. The current database user must be the owner of the specified table.

The specified trigger name must identify an existing trigger of the table.

The metadata of the trigger is dropped.