25 Mar
2010
25 Mar
'10
8 p.m.
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.
So, is there any way to re-order columns other than by creating a new table with the required column order, copying all the data across, deleting the old table and renaming the new one?
I can't find any neat utilities out there to do this for me.
--
Chris Green