How to delete table using Alembic?

Question

I want to delete a bunch of code from my application including several models.

I tried deleting the file that defines the models and then did an Alemic autogenerate but the generated migration file did not appear to remove the corresponding tables.

Any suggestions for how to do deletion in order to clear out no longer used code?

thanks

that approach *should* work – Antti Haapala -- Слава Україні Sep 10 '17 at 11:16 — Antti Haapala -- Слава Україні, Sep 10 '17 at 11:16

score 2 · Answer 1 · answered May 04 '16 at 03:33

2

In your alembic migration, in the 'upgrade' function, just do something like:

from alembic import op
for table in ('table_a', 'table_b'):
    op.drop_table(table)

answered May 04 '16 at 03:33

Robin Davis

622
4
10

So essentially I have to do it manually? I'll just doing it all using plsql then I guess. – Duke Dougal May 04 '16 at 04:27
1

@DukeDougal a bit late of an answer, but alembic isn't just about manual vs. automatic AFAIU, it's also about keeping things in order by using revisions, being able to downgrade, etc.. (so I'd accept this Robin's answer :) ) – yair May 19 '19 at 22:01

Simi Lika · Answer 2 · 2022-08-25T15:02:10.687

1

You can use this on the terminal:

alembic downgrade base or alembic downgrade 2438c2e44a3e where this version is the version that is before the one you want to work with. On alembic version file it is shown as down_revision = '2438c2e44a3e'

edited Aug 25 '22 at 15:02

answered Jul 25 '22 at 15:28

Simi Lika

53
8

How to delete table using Alembic?

2 Answers2