I have tried Alter table your_table (order colname15, colname16,...colname20)
Colname have to be the real column names (with my 6.5, the alter table does not accept "COLn" as a column name). You do not have to specify the order of the other 14. Jacques Paris -----Original Message----- From: Simon Roy [mailto:[EMAIL PROTECTED] Sent: 9-Jul-03 11:29 To: Mapinfo-L Subject: MI-L Columns order Hi all, I have many tables with 20 columns in each. I want to bring the last 6 columns up so they appear first in the table structure. The name/format of the 14 first columns are different from a table to another. I am looking for a way to do this automatically thru MB. Hope I'm clear enough Thanks! Simon Roy ----------------------------------------- GIS Specialist Carto-M�dia, Environnement Illimit� inc. tel.:514-849-7281 fax.:514-849-6770 ----------------------------------------- --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7563
