On Mon, Oct 8, 2012 at 3:57 PM, Yves Goergen <[email protected]>wrote:

>
> Why does SQLite still not support dropping columns
> through SQL after all these years?
>

The only ALTER TABLE functions that SQLite supports are those that can be
accomplished without having to rewrite the entire table.  Or, to put it
another way, the only ALTER TABLE functions supported are those that can be
done in O(1) time.

ALTER TABLE DROP COLUMN requires writing every row of the table.

-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to