Small. Fast. Reliable.
Choose any three.

drop-trigger-stmt:

DROP TRIGGER IF EXISTS schema-name . trigger-name

R-61172-15671:[The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. ] R-04950-25529:[Once removed, the trigger definition is no longer present in the sqlite_schema (or sqlite_temp_schema) table and is not fired by any subsequent INSERT, UPDATE or DELETE statements. ]

R-37808-62273:[Note that triggers are automatically dropped when the associated table is dropped. ]