Chris G wrote:
I know it isn't really necessary as it doesn't actually affect anything (except my sensibilities) but I'd like the ability to re-order columns in some sqlite databases.
Well, it *does* have some advantages, it would mean I can do things like "SELECT * FROM database" and get the columns displayed in the order I want rather than the order resulting from database creation followed by adding extra columns as I found I needed them.
That would be crazy as every time you wanted a different order you would have to re-order the tables and then every time you insert a row, guess what....you would have to re-order the tables again.
The correct way to do this surely is to order results on your queries not on the data itself
SELECT * FROM table ORDER BY column
of course you can also specify multiple columns so if say you wanted to surname and then date of birth then two identical surnames would be ordered with the oldest one first. it's naturally also possible to reverse the order etc