mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep -i ^DROP 

例：

C:\mysqldump -uroot --add-drop-table --no-data  ip|grep -i ^drop

DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `ads`;
DROP TABLE IF EXISTS `ads_position`;
DROP TABLE IF EXISTS `articles`;
DROP TABLE IF EXISTS `categories`;
DROP TABLE IF EXISTS `commentation`;
DROP TABLE IF EXISTS `countries`;
DROP TABLE IF EXISTS `exchangerate`;
DROP TABLE IF EXISTS `favorites`;
DROP TABLE IF EXISTS `formquestions`;
DROP TABLE IF EXISTS `forms`;
DROP TABLE IF EXISTS `futureusers`;
DROP TABLE IF EXISTS `listingimages`;
DROP TABLE IF EXISTS `listings`;
DROP TABLE IF EXISTS `listings2`;
DROP TABLE IF EXISTS `newactions`;
DROP TABLE IF EXISTS `news`;
DROP TABLE IF EXISTS `payment`;
DROP TABLE IF EXISTS `property_types`;
DROP TABLE IF EXISTS `propertyviews`;
DROP TABLE IF EXISTS `qa`;
DROP TABLE IF EXISTS `regions`;
DROP TABLE IF EXISTS `replies`;
DROP TABLE IF EXISTS `submitedforms`;
DROP TABLE IF EXISTS `subscibers`;
DROP TABLE IF EXISTS `tagowners`;
DROP TABLE IF EXISTS `tags`;
DROP TABLE IF EXISTS `test`;
DROP TABLE IF EXISTS `visits`;
DROP TABLE IF EXISTS `votes`;