Skip to content

Instantly share code, notes, and snippets.

@jarnaldich

jarnaldich/delete_from_all_tables.sql

Created December 13, 2022 06:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jarnaldich/d72a803495951271770968f7add3e54a to your computer and use it in GitHub Desktop.
Save jarnaldich/d72a803495951271770968f7add3e54a to your computer and use it in GitHub Desktop.
Download ZIP
[ Delete from all tables in SQLITE ] Script to delete all tables from SQLITE #sqlite #sql #metaprogramming
Raw
delete_from_all_tables.sql
.output wipe.sql
select 'DELETE FROM ' || name || ';' FROM sqlite_master WHERE type='table';
.output
.read wipe.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment