DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Drop An Entire Schema

12.10.2005
| 2043 views |
  • submit to reddit
        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.