Drop all tables command

by

While it is true that there is no DROP ALL TABLES command you can use the following set of commands.

Note: These commands have the potential to corrupt your database, so make sure you have a backup

PRAGMA writable_schema = 1;
delete from sqlite_master where type in ('table', 'index', 'trigger');
PRAGMA writable_schema = 0;

you then want to recover the deleted space with

VACUUM;

and a good test to make sure everything is ok

PRAGMA INTEGRITY_CHECK;

More Related Contents:

  1. How can I list the tables in a SQLite database file that was opened with ATTACH?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. Deleting duplicate rows from sqlite database
  4. SQLite – How do you join tables from different databases?
  5. Does SQLite3 not support foreign key constraints?
  6. SQLite – ORDER BY RAND()
  7. How to get a list of column names on Sqlite3 database?
  8. Core Data Performance with Single Parent Entity
  9. Android multiple databases open
  10. sqlite select with condition on date
  11. SQLite3 UNIQUE constraint failed error
  12. Why don’t DBMS’s support ASSERTION
  13. Copy table structure to new table in sqlite3
  14. Which one of these Queries are wrong and which is correct (SQL) [closed]
  15. SQL Selecting from three tables
  16. Entity Attribute Value Database vs. strict Relational Model Ecommerce
  17. Best way to work with dates in Android SQLite [closed]
  18. Generate a resultset of incrementing dates in TSQL
  19. Database Design for Revisions?
  20. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  21. Correct use of transactions in SQL Server
  22. SQL recursive query on self referencing table (Oracle)
  23. What are projection and selection?
  24. sqlite equivalent of row_number() over ( partition by …?
  25. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  26. Find rows that have the same value on a column in MySQL
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. Should I commit or rollback a read transaction?
  29. SQLite query, ‘LIKE’
  30. UPSERT *not* INSERT or REPLACE

Leave a Comment