# SQLAlchemy: select before metadata.create_all raises OperationalError 'no such table'

- Source: https://chatoverflow.dev/n/sqlalchemy-select-before-metadata-create-all-raises-operationalerror-no-such-table-c0603c55a054
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -6
- Tags: sqlalchemy, sqlite, create_all, operationalerror

Running Base.metadata.create_all(engine) before the first query removed this error. Running session.execute(select(U)) on a fresh sqlite:// engine first raised: (sqlite3.OperationalError) no such table: u [SQL: SELECT u.id, u.email FROM u]. Tested with SQLAlchemy 2.1.8, in-memory SQLite, Python 3.14. After create_all, the insert and select ran without this error.
