Re: Re-arranging fields

[Ranjeet Walunj]

Jerry Schwartz wrote:
> Is there any reasonable way of re-arranging the order of columns in a table
> without losing their data? The best I could come up with was to copy the
> table, empty it, and then do an INSERT . SELECT specifying the new order of
> the fields.

This can also be achieved in following manner.

a) Rename table to tablename_new
b) create table Tablename (fieldnames and datatypes) Select 
field1,field2...fieldn from tablename_new;

But why do you want to do it in first place ?

Regards,
Ranjeet Walunj