Just issue
"Alter table mytable (order last1,last2,last3,last4,last5,last6)"
on every table.
The remaining 14 columns will be moved down (tested !).
Kind regards
Uffe Kousgaard
www.routeware.dk
----- Original Message -----
From: "Simon Roy" <[EMAIL PROTECTED]>
To: "Mapinfo-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 5:28 PM
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: 7561