SQLITE_DBCONFIG_RESET_DATABASE

Set the SQLITE_DBCONFIG_RESET_DATABASE flag and then run VACUUM in order to reset a database back to an empty database with no schema and no content. The following process works even for a badly corrupted database file: If the database connection is newly opened, make sure it has read the database schema by preparing then discarding some query against the database, or calling sqlite3_table_column_metadata(), ignoring any errors. This step is only necessary if the application desires to keep the database in WAL mode after the reset if it was in WAL mode before the reset.

• sqlite3_db_config(db, SQLITE_DBCONFIG_RESET_DATABASE, 1, 0);

• sqlite3_exec(db, "VACUUM", 0, 0, 0);

• sqlite3_db_config(db, SQLITE_DBCONFIG_RESET_DATABASE, 0, 0); Because resetting a database is destructive and irreversible, the process requires the use of this obscure API and multiple steps to help ensure that it does not happen by accident. Because this feature must be capable of resetting corrupt databases, and shutting down virtual tables may require access to that corrupt storage, the library must abandon any installed virtual tables without calling their xDestroy() methods.

Additional sqlite3_db_config() arguments: int int*