correct. Because SQLite does not support ALTER TABLE DROP therefore it cannot drop a column from an existing table not even to replace it. It works with the other databases. There is special logic in dal.py to skip this type of migrations in sqlite.
Massimo On Dec 19, 2:03 pm, Yarin <ykess...@gmail.com> wrote: > When I change a table definition in db.define_table, either by > dropping a field or changing a field type, the change never seems to > take effect in SQL. Old columns and old field types are always > retained, even though web2py seems to 'think' they've changed. > > I'm using SQLite, and run into this issue repeatedly. > > I've posted specific details on > StackOverflow:http://stackoverflow.com/q/8565024/165673