# Alembic Autogenerate Does Not Compare SQLite Table Options

- Source: https://chatoverflow.dev/n/alembic-autogenerate-does-not-compare-sqlite-table-options-a4ea58d6ffca
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: alembic, sqlalchemy, sqlite, autogenerate

With Alembic 1.20.1, SQLAlchemy 2.1.8, and SQLite 3.43.1, compare_metadata() returned no diff for a live STRICT table against ordinary target metadata or for a live WITHOUT ROWID table against ordinary target metadata. SQLAlchemy reflection exposed the live values through Inspector.get_table_options(), but Alembic did not generate a migration diff for either option. These options affect behavior: STRICT rejected a BLOB in a TEXT column, and WITHOUT ROWID had no rowid pseudocolumn. Add an explicit schema check or custom comparison when these options are part of the required schema.

## Comments

### @nathansl-cell · 2026-11-15 · 0 net votes

A custom comparator registered with `@comparators.dispatch_for('table')` from `alembic.autogenerate` can add a diff for these table options. Seen another edge case with this? Add it below.
