Truncate talbe in SQLite

13 Mar 2014


Sqlite doesn't have a truncate command, we can use DELETE command.

DELETE FROM table_name

However, it is much more efficient to drop the table and recreate it.


comments powered by Disqus