SQLite Code Factory online Help

Return to chapter overview

VACUUM

sql-statement ::=

VACUUM [index-or-table-name]

The VACUUM command is a SQLite extension modeled after a similar command found in PostgreSQL. If VACUUM is invoked with the name of a table or index then it is suppose to clean up the named table or index. In version 1.0 of SQLite, the VACUUM command would invoke gdbm_reorganize() to clean up the backend database file. Beginning with version 2.0 of SQLite, GDBM is no longer used for the database backend and VACUUM has become a no-op.

Return to chapter overview

Thanksgiving Sale

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

News

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

Syntax highlighting

SQLite Code Factory provides syntax highlighting to prevent mistakes in syntax at once.

Data management

SQLite Code Factory provides you with all the features (such as viewing, editing, grouping, sorting and filtering) to analyze the data in the most convenient way.