Quote:
Originally Posted by davidfor
The SQLite browser will have somewhere to run an SQL statement. You can enter "vacuum" in that and run it. The menu simple is a shortcut to running the statement.
As to why they chose "vacuum" for the name of the statement, I don't know. From my DB2 and SQLServer days, I think of it as "reorganize". "Compress" is a good generic term.
|
Right the free version has three major tabs "Database Structure" "Browse Data" and "Execute SQL". I ran "vacuum" as a query and it reported "No Error", but I don't think it did much. There was nothing in the "Data returned:" area.
So in the windows version of SQLite the "File" tab selection "Compact Database" means what? Is it not what you guys are talking about or do you only get that in the "Expert" version?
Luck;
Ken