Whats the easiest way to change the order of fields in a table structure?
There isn't AFAIK. But if you're doing 'SELECT * FROM table_name' and you want the
order changed, then you can 'SELECT' the column names in the order you want ie.
'SELECT second_field,first_field FROM table_name'.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by gjs:
Whats the easiest way to change the order of fields in a table structure?[/quote]
One way is to copy the table to something else then re-create it with the columns in right order, e.g. you have a table with three columns a,b and c:
create table table_copy
select * from orig_table;
<you now have a copy of orig_table in table_copy>
Then:
drop table orig_table;
and finally:
create table new_ordered_table
select b,c,a from table_copy ;