DROP TRIGGER


drop-trigger-stmt:

syntax diagram drop-trigger-stmt


The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. The trigger is deleted from the database schema. Note that triggers are automatically dropped when the associated table is dropped.