SQLite Forum

DROP COLUMN feature with indexes
> The errors thrown are pretty clear, and are enough to suggest what index(es) need to be dropped before a retry. Dropping an index seems a bit much to me. 

I agree. I would not want to silently lose an index because I forgot it was using a column I no longer care about.