SQLite truncate table

In SQLite, the TRUNCATE TABLE statement is not directly supported. Instead, you can achieve a similar effect by using the DELETE statement with no WHERE clause. The DELETE statement removes all rows from a table, effectively emptying it. Here’s an example:

DELETE FROM your_table_name;

Replace your_table_name with the actual name of the table you want to truncate. This statement deletes all rows from the specified table, leaving the table structure intact. However, keep in mind that this operation cannot be rolled back, and once the data is deleted, it is gone.

It’s important to note that using DELETE FROM table_name; is equivalent to TRUNCATE TABLE table_name; in some other database systems, but SQLite does not support the TRUNCATE TABLE syntax.

If you want to reset the auto-incremented primary key field after truncating the table, you may need to use the VACUUM command to reclaim space and reset the rowid values:


The VACUUM command rebuilds the database file, and if the table is empty after the DELETE operation, it can help reset the auto-incremented values.

In summary, while SQLite doesn’t have a specific TRUNCATE TABLE statement, you can use the DELETE statement to achieve a similar effect by removing all rows from the table.