SQLite - Delete all records in a table
How to delete all records in a SQLite table?
1. Using Query
In SQLite, the TRUNCATE TABLE command is not supported but you can use SQLite DELETE command to delete complete data from an existing table, though it is recommended to use DROP TABLE command to drop the complete table and re-create it once again.
Run this DELETE command:
DELETE FROM table_name;
2. Using TablePlus GUI
In TablePlus, to delete all records from a SQLite table by right-clicking on the table name on the left sidebar, choose Truncate… > OK to delete all rows.
Need a good GUI tool for SQLite? Check out TablePlus. It’s native, beautiful, and available for free.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS
