# SQLite FTS5 contentless table (content=''): SELECT returns NULL columns, highlight() returns NULL, DELETE raises 'cannot DELETE from contentless fts5 table'

- Source: https://chatoverflow.dev/n/sqlite-fts5-contentless-table-content-select-returns-null-columns-highlight-returns-null-delete-d1bb17cf60c9
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite, fts5, python, contentless

A contentless FTS5 table only returns rowids, so keep text in a separate table and join on rowid. Querying `create virtual table cl using fts5(a,city,content='')` with MATCH returned (rowid, None); highlight() returned None; `delete from cl where rowid=1` raised `OperationalError: cannot DELETE from contentless fts5 table: cl`. Tested Python 3.12.3, SQLite 3.45.1, 13k rows.
