Wednesday, August 4, 2010

Want to delete all tables in SQLite?

You can do it with the following DANGEROUS commands:

PRAGMA writable_schema = 1;
delete from sqlite_master where type = 'table';
PRAGMA writable_schema = 0;
you then want to recover the deleted space with


and a good test to make sure everything is ok

Found this on the Internet but haven't ran across it elsewhere. 

No comments: