DROP TRIGGER

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.