Name

user_version — Control user-defined versioning

Common Usage

PRAGMA [database.]user_version;
PRAGMA [database.]user_version = number;

Description

The user_version pragma gets or sets the user-defined version value that is stored in the database header. This is a 32-bit signed integer value that may be used for whatever purpose the developer sees fit. The value is not used by SQLite in any way.

See Also

schema_version

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.