SQLite Forum

DROP COLUMN feature with indexes
Login
I should think the ALTER TABLE command should fail with an error that the column is being used.  This should apply not only to indexes but also to triggers and views which reference the column being dropped explicitly.

In the normal case executing a DDL command should not result in an inconsistent schema.

If pragma legacy_alter_table is in effect then any indexes referencing the column should be dropped and explicit uses of the column name in triggers or views should be ignored.