schemaVersion

Queries or sets the schema_version of the database.

This pragma holds an integer that is automatically incremented by SQLite whenever a schema-altering statement (like CREATE TABLE, DROP TABLE, or ALTER TABLE) is executed. It is used internally by SQLite to invalidate cached prepared statements when the schema changes.

While this value is automatically managed by SQLite, applications can also write to it. This can be useful, for example, to force other database connections to re-prepare their statements if an application-level schema change has occurred that SQLite would not otherwise detect. (such as a change in the meaning of a function or a custom collation sequence).

Setting this value manually is an advanced feature and should be done with care.

See also