Separate storage from the FTS index when needed.
Section: Create FTS5 tables
Use an external content table pattern
sql
sql
CREATE TABLE articles (
id INTEGER PRIMARY KEY,
title TEXT,
body TEXT
);
CREATE VIRTUAL TABLE articles_fts USING fts5(
title,
body,
content='articles',
content_rowid='id'
);Explanation
Common when the app needs a normal table plus a search index over the same content.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Create FTS5 tables