I vote for dropping them. It would be consistent with DROP TABLE behaviour for indexes. On a related note, I'm not sure how much schema checking SQLite does for triggers, but CREATE TRIGGER x BEFORE UPDATE OF z ON c1 also remains unmodified after a column is dropped.