Add column after another column

Question

How can I add a column after another column to a database using Alembic or SQLAlchemy? That would be equivalent to this SQL clause:

ALTER TABLE foo
CHANGE COLUMN bar
bar COLUMN_DEFINITION_HERE
AFTER OTHER_COLUMN;
-- or
ALTER TABLE foo ADD COLUMN baz AFTER bar;

I also tried the suggestion in this mailing list thread, but it didn't help.

While the order doesn't matter when querying, it helps readability for large tables when in the SQL shell.

There's an answer here: http://stackoverflow.com/questions/17541312/alter-table-add-multiple-columns-after-column1 — mba12, Jun 28 '16 at 20:00
@mba12: that's about the SQL syntax, not on how to do this with SQLAlchemy's tooling. — Martijn Pieters, May 22 '19 at 11:44

score -1 · Answer 1 · answered Jun 03 '20 at 05:17

-1

Try this query :

ALTER TABLE table_name ADD New_column_name column_definition AFTER column_name;

answered Jun 03 '20 at 05:17

Purvi Barot

score -4 · Answer 2 · edited Sep 05 '18 at 05:43

-4

Use ALTER with AFTER to specify where to place the column.

ALTER TABLE foo 
CHANGE COLUMN foo1 foo1 INT(10) UNSIGNED NULL DEFAULT NULL AFTER foo2;

edited Sep 05 '18 at 05:43

davidism

answered Feb 10 '17 at 14:13

Ton

Yes, that's the syntax the OP wants to *generate* using either of the SQLAlchemy schema migration management tools, so Alembic or SQLAlchemy-Migrate. Your answer doesn't cover that. – Martijn Pieters May 22 '19 at 11:43

2 Answers2