On 9 Jun 2018, at 4:28pm, Jay Kreibich <j...@kreibi.ch> wrote:

> If a full VACUUM is not feasible, you can simply copy the table after the 
> column is removed.

Note that SQLite has special optimization for the command

        DELETE FROM oldTable

with no "WHERE" clause.  So the best way to do it would be

        BEGIN;
        CREATE tempTable AS SELECT * FROM oldTable;
        DELETE FROM oldTable;
        INSERT INTO oldTable SELECT * FROM tempTable;
        COMMIT;

Of course, if this is the master table for a foreign key, you have additional 
problems.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to