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