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.)

Parent topic: DROP statements

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