Ferindo, > Is there a way to change the position attribute of a column > in a table?
AFAIK, there's no way to change this easily. The best way to do it would be as follows: BEGIN WORK; LOCK TABLE mytable IN ACCESS EXCLUSIVE MODE; ALTER TABLE mytable ADD COLUMN col_to_move_2 coltype; UPDATE mytable SET col_to_move_2 = col_to_move; ALTER TABLE mytable DROP COLUMN col_to_move; ALTER TABLE mytable RENAME col_to_move_2 TO col_to_move; COMMIT WORK; Best regards, Ben Stewart -- Robert Bosch (Australia) Pty. Ltd. Engineering Quality Services, Student Software Engineer (RBAU/EQS4) Locked Bag 66 - Clayton South, VIC 3169 - AUSTRALIA mailto:[EMAIL PROTECTED] http://www.bosch.com.au/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings