On Mon, Feb 6, 2012 at 9:36 AM, Bill McCormick <wpmccorm...@gmail.com> wrote: > Is there no way to force columns added to a table with alter table to be > added at certain column positions? > > Alternatively, if there is some way to save the data in an existing table; > drop the table; re-create the table with the desired schema; and then reload > the data, this would be useful as well. However, I cannot see how to do this > simply.
If order of columns is only important for aesthetic reasons you might just use a ALTER TABLE to add the column at the end of the list and then a VIEW to provide the view you prefer. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users