Quick and dirty on linux based systems:
mysql -u$DB_USER -p$DB_PASS -D$DB_NAME -h$DB_HOST -e "show tables" -s \ | awk \ -v DB_USER=$DB_USER \ -v DB_PASS=$DB_PASS \ -v DB_NAME=$DB_NAME \ -v DB_HOST=$DB_HOST \ '{ print "mysql -u"DB_USER" -p"DB_PASS" -D"DB_NAME" -h"DB_HOST" -e \"DROP TABLE "$1"\""}' \ | sh