SQL As Understood By SQLite

DROP TRIGGER

drop-trigger-stmt:

The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. The trigger is deleted from the database schema. Note that triggers are automatically dropped when the associated table is dropped.