Remove a trigger
DROP TRIGGER [IF EXISTS] [database-name.] trigger-name
The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. The trigger is deleted from the database schema.
Triggers are automatically dropped when the associated table is dropped.