DROP TRIGGER statement

DROP TRIGGER removes the specified trigger.

Syntax

DROP TRIGGER TriggerName

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