Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Drop An Entire Schema

DZone's Guide to

Drop An Entire Schema

·
Free Resource
In MySQL, if you have a file with your schema and want to drop all your tables, use this one-liner from shell:


perl -ne '/^\s*create\s+table\s+(\S+)/ && print "drop table if exists $1;\n"' schema.sql | mysql 


Add your username, password and database to the mysql call.
Topics:

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}