SQLite Filesize is still not change after drop table
php, sql, sqlite
Solution
You need to read https://stackoverflow.com/a/2143808/2198378
Although file size was same, data will be overridden.
To avoid it, refer VACUUM and auto_vacuum.
Problem
- I have a SQLite Database 4MB. - I used command drop table `name`; and I dropped it. I checked in SQlite Manager that no more table `name`. - However, I checked the filesize, it is still 4MB, the same. - I use NotePade, open the Database I see the old contents which I have inserted are still there. Did I do anything wrong on drop table command? or SQLite keeps old data and filesize will the same? Thanks your help.