George Mavroudes wrote:
If I delete all records from a [tableName] and then execute the VACUUM
command, will this temporarily delete the table (causing a SCHEMA_CHANGE)
and then add this table back into the db?
George,
Yes, SQLite has an optimization which replaces a delete without a where
clause with a drop table and then a create table (using the create
statement stored in the sqlite_master table). This is done because it is
much faster than scanning and deleting all records one at a time. The
drop/create should cause a schema change.
HTH
Dennis Cote
