How to Truncate table in SQLite database
June 4th, 2008 by 
Jon Moffet
I found out that truncating SQLite database is a little bit different from its MySQL counterpart. Here's how to truncate SQLite database from command line
CODE:
-
sqlite your_database.db
-
sqlite> DELETE FROM some_table;
after that, dont forget to execute VACUUM to compact the database :
CODE:
-
sqlite> VACUUM;
Posted in Uncategorized | 