May 16, 2021 SQLite
In SQLite, there is no TRUNCATE TABLE command, but you can use SQLite's DELETE command to remove all data from an existing table, but it is recommended that you use the DROP TABLE command to delete the entire table and then re-create it.
The basic syntax of the DELETE command is as follows:
sqlite> DELETE FROM table_name;
The basic syntax of DROP TABLE is as follows:
sqlite> DROP TABLE table_name;
If you use the DELETE TABLE command to delete all records, it is recommended that you use the VACUUM command to clear unused space.
Suppose the COMPANY table has the following records:
ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 1 Paul 32 California 20000.0 2 Allen 25 Texas 15000.0 3 Teddy 23 Norway 20000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 6 Kim 22 South-Hall 45000.0 7 James 24 Houston 10000.0
Here are the instances that deleted the records in the table above:
SQLite> DELETE FROM COMPANY; SQLite> VACUUM;
The records in the COMPANY table are now completely deleted and there will be no output using the SELECT statement.