Example Create a table: CREATE TABLE t ( a INT, b INT, d INT, e INT ); Add a column: ALTER TABLE t ADD (c INT); Move the column to the middle: ALTER TABLE t MODIFY (d INVISIBLE, e INVISIBLE); ALTER TABLE t MODIFY (d VISIBLE, e VISIBLE); DESCRIBE t; Name ---- A B C D E