Indeed those two possibilities! And perhaps also to MODIFY a column. We alter tables all the time :)
The possibility to specify at which place an added column should appear when I do a "SELECT * ..." would be a nice extra, in MySQL it is done like: ALTER TABLE table_name ADD COLUMN col_name1 [_AFTER_ col_name2 | FIRST] Gr., Gunnar On 12/24/2015 05:14 PM, Simon Slavin wrote: > On 24 Dec 2015, at 3:12pm, John McKown <john.archie.mckown at gmail.com> > wrote: > >> ?I'm curious as to why. Doing so would, most likely, require rewriting the >> entire table. If you want a SELECT * to get the columns in a particular >> order, just create a VIEW with the columns in the order in which you want >> them. > I think Gunnar just wants forms such as > > ALTER TABLE CREATE COLUMN ... > ALTER TABLE DROP COLUMN ... > > to aid with making small changes to the schema. These are available in most > SQL engines but the way SQLite3 is written makes it difficult or inefficient > to implement them. > > I have a database where one table takes up more than 30 Gigabytes of space. > While developing the software I needed several times to change a column > definition and since SQLite lacks these facilities I had to move 30 Gig of > data around every time I did it. Annoying. But it's not normally that much > of a problem for me. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
