SQLite Forum

Apparent bug in ALTER TABLE
Login
Without "PRAGMA legacy_alter_table = 0", the ALTER TABLE command will not even attempt to operate on schemas that contain views with missing references. So the error is being produced before ALTER TABLE even looks at the new table name.