how to change order of fields??

[ironmansp]

I have several tables on a database. How can I reorder the name of the fields of the tables? I want to reorder the names but I can not how to do it... Suggestions please?

[Mätes]

i think there is no (easy) way to reorder the fields.

one way is to create a new table with the same fields and a new order,
copy the data and rename both tables.
its a littlebit more to do if there are any constraints or anything else.

ms-sql-server also has no function to do it, but one tool (sql-manager) provides a small wizard to do it, and he executes all the steps mentioned above.

possible there are tools for mysql that can help you.
try SQLYog http://www.webyog.com/en/
or HeidiSQL http://www.heidisql.com/

ciao,
ma