The DROP TRIGGER statement removes the specified trigger.
A trigger is created by a CREATE TRIGGER statement.
DROP TRIGGER triggerName
DROP TRIGGER TRIG1
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.)