Syntax:
DROP TRIGGER [ IF EXISTS ] trigger-name
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.