DROP TRIGGER

The DROP TRIGGER statement removes the specified trigger.

Syntax

DROP TRIGGER TriggerName

TriggerName

The name of the trigger that you want to drop from your database.

Example

splice> DROP TRIGGER UpdateSingles;
0 rows inserted/updated/deleted

Statement dependency system

When a table is dropped, all triggers on that table are automatically dropped; this means that do not have to drop a table’s triggers before dropping the table.

See Also