jarnaldich/delete_from_all_tables.sql

Created December 13, 2022 06:05

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jarnaldich/d72a803495951271770968f7add3e54a.js"></script>
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