首页 > 代码库 > SQLite - TRUNCATE TABLE

SQLite - TRUNCATE TABLE

https://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

Unfortunately, no TRUNCATE TABLE in SQLite but DELETE to delete complete data from an existing table,
though it is recommended to use DROP TABLE to drop complete table and re-create it once again.

If you are using DELETE TABLE to delete all the records, it is recommended to use VACUUM to clear unused space.

DELETE FROM table_name;
VACUUM;
DROP TABLE table_name;

SQLite - TRUNCATE TABLE