DROP TRIGGER removes the specified trigger.
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.)