Normally I could drop and create database from scratch, but what if user doesn't have permission to do that?

Also I wouldn't like to specify my credentials in the command-line (1. it's hard to type, especially complex passwords, 2. it's not safe as it get stored in shell history files and on the process list).

Therefore how I can drop all tables using drush?


1 Answer 1


It seems there is a single drush command to Drop all tables in a given database. Just run:

$ drush sql-drop

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.