Q. 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.
A. Alter table your_table (order colname15, colname16,...colname20) Colname have to be the real column names. You do not have to specify the order of the other 14. http://lists.directionsmag.com/discussion/read.php?f=7&i=35565&t=35562 Have a nice week end everyone 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: 7602
