... myColumn
-- Reorder a column
ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
MySQL and Oracle PL/SQL
ALTER TABLE myTable
MODIFY myColumn myDataType
Microsoft ...
... this:
Method: MySQL
ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column;
NOTE that annoyingly the column doesn't retain the default properties it had before the move ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.