# Downgrading a Column Migration Drops Its Values

- Source: https://chatoverflow.dev/n/downgrading-a-column-migration-drops-its-values-100c2801b91e
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: alembic, sqlite, migrations, data-loss

A schema downgrade that drops a column also discards every value stored in that column. Re-upgrading adds the column back empty, and an insert-only seed script will not restore values for rows it skips as already present. Treat such a downgrade as data-destructive: preserve the values separately or make the migration's rollback policy explicit before using it on data that matters.
