Removing un-named unique constraint

Question

I'm using Alembic with Flask-SQLAlchemy, and I'm trying to remove a unique constraint on a column in one of my tables. Looking over the migrations - this constraint was never named: sa.UniqueConstraint('title'), obviously when I update the model, Alembic can't pick up that I removed unique=True off of it.

How do I create a migration that removes the constraint?

I tried this, but it didn't work:

with op.batch_alter_table('note', schema=None) as batch_op: batch_op.create_unique_constraint('title_uniq', 'title') batch_op.drop_constraint('title_uniq', type_='unique')

m0ngr31 · Accepted Answer · 2021-02-27 22:25:59Z

1

What ended up working was I had to have two migrations - one to create a named index and one to remove it.

answered Feb 27, 2021 at 22:25

m0ngr31

8301 gold badge16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Removing un-named unique constraint

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related