SQLite Drop Column

 

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE test_backup(a,b);
INSERT INTO test_backup SELECT a,b FROM test;
DROP TABLE test;
CREATE TABLE test(a,b);
INSERT INTO test SELECT a,b FROM test_backup;
DROP TABLE test_backup;
COMMIT;