broozer/psa — Issue #1: drop table columns
Author: broozer
Created: 2012-01-21 14:03:57+00:00
State: open

When opening the table structure you will get the option to drop a column.

http://github.com - automatic!
[GitHub](http://github.com)

Based on the official sqlite website

[FAQ](http://www.sqlite.org/faq.html#q11)

it can be done by the following

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