Home / Questions / 500798
Accepted
Iván Rodríguez
Asked: 2022-05-02 18:26:16 +0800 CST 2022-05-02 18:26:16 +0800 CST

SQLite: How to physically remove all data from a table?

  • 772

I am using the following code to drop my database tables.

"DROP TABLE IF EXISTS TableName;"

The tables are deleted but I have noticed that the data is still inside the file. That is, after executing this command I would expect my file to have zero bytes, yet the file does not lose a single byte of its size.

Is there a way to delete the table and also all the data in that table?

sqlite

1 Answers

  1. Best Answer

    The deletion of a table, as you have already realized, is simply a logical deletion, the structure and the data are still physically in the database, the used space is recovered as needed. To delete and reorganize the physical file of a database sqliteyou have the clause VACCUM. Executing this command reorganizes the database space to the bare minimum, reducing space and data fragmentation.

    • 2