Brett Parker wrote:

In case one wasn't aware, all fields in sqlite are text. Nothing else. It doesn't do type checking.

It is not really so simple. Please have a look at http://www.sqlite.org/datatype3.html

For reordering the columns of a table one could resort to a temporary table.

create temporary table temptab as select column4, column3, column2, column1 from sometable;

select * from temptab;

I think that this is more flexible than reordering the columns of the main table. Remember that "temptab" is temporary and lasts only the current session, something I consider a feature.

Govind Chandra