DROP TRIGGER statement

The DROP TRIGGER statement removes the specified trigger.

A trigger is created by a CREATE TRIGGER statement.

Syntax

DROP TRIGGER triggerName

Example

DROP TRIGGER TRIG1

Statement dependency system

When a table is dropped, all triggers on that table are automatically dropped. (You don't have to drop a table's triggers before dropping the table.)

Related reference
DROP DERBY AGGREGATE statement
DROP FUNCTION statement
DROP INDEX statement
DROP PROCEDURE statement
DROP ROLE statement
DROP SCHEMA statement
DROP SEQUENCE statement
DROP SYNONYM statement
DROP TABLE statement
DROP TYPE statement
DROP VIEW statement