autoVacuum

Queries or set the auto-vacuum mode.

The value is an integer representing the auto-vacuum mode:

• 0: (NONE) - Auto-vacuum is disabled.

• 1: (FULL) - Full auto-vacuum mode.

• 2: (INCREMENTAL) - Incremental vacuum mode.

This pragma must be set before any tables are created in the database. It is not possible to change the auto-vacuum mode of a database after it has been created.

For more details, see the SQLite PRAGMA auto_vacuum documentation.

See also