The syntax for a dropping a Trigger is:
DROP TRIGGER trigger_name;
For example:
If you had a trigger called orders_before_insert, you could drop it with the following command:
DROP TRIGGER orders_before_insert;
From www.techonthenet.com