SQLite Forum

DROP COLUMN feature with indexes
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.