Drop An Entire Schema
Join the DZone community and get the full member experience.Join For Free
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 | mysqlAdd your username, password and database to the mysql call.
Opinions expressed by DZone contributors are their own.