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.
