How do you VACUUM SQLite?

How does SQLite VACUUM work?

The VACUUM command works by copying the contents of the database into a temporary database file and then overwriting the original with the contents of the temporary file. When overwriting the original, a rollback journal or write-ahead log WAL file is used just as it would be for any other database transaction.

How do I purge SQLite database?

sqlite> DELETE FROM table_name; Following is the basic syntax of DROP TABLE. sqlite> DROP TABLE table_name; If you are using DELETE TABLE command to delete all the records, it is recommended to use VACUUM command to clear unused space.

How do I truncate a table in SQLite?

SQLite does not have an explicit TRUNCATE TABLE command like other databases. Instead, it has added a TRUNCATE optimizer to the DELETE statement. To truncate a table in SQLite, you just need to execute a DELETE statement without a WHERE clause. The TRUNCATE optimizer handles the rest.

What does VACUUM command do?

VACUUM FULL: This is the default VACUUM command. It sorts the specified table and reclaims any disc space cleared out by DELETE or UPDATE commands. One can specify a specific table to VACUUM, or it can do an entire database (this operation can take a long time).