SQLite Filesize still not changing after drop table

  • I have a SQLite 4MB database.
  • I used the drop table command name; and I threw it. I checked in SQlite Manager that there is no more table name.
  • However, I checked the file size, it is still 4 MB, the same.
  • I use NotePade, open the database, I see that the old content that I inserted is still there.

Did I do something wrong with the drop table command? or does SQLite keep old data and file size the same?

Thanks for the help.

+5
source share
1 answer

You need to read fooobar.com/questions/134760 / ...

Although the file size was the same, the data will be overridden.

, VACUUM auto_vacuum.

+6

All Articles