The System Menu

Less used but still useful database tasks are grouped in this menu.

Caution

All actions introduced here requires deep understanding of the Sqlite internals – study its documentation, please.

System->Analyze Statistics...

Raise a dialog to compute the database statistics. You can drop, compute statistics for the whole schema, or just select objects.

System->Vacuum...

Raise a dialog to handle free space in the database file.

System->Attach Database...

You can join another Sqlite database file into this session. See full Attach Database documentation.