Ameer Khan

Command:-
mysqldump -u[user] -p[password] –add-drop-table –no-data [DATABASE] | grep ^DROP | mysql -u[user] -p[password] [DATABASE]

Here test is the database name. I’m going to drop all the tables from this database.
Example:-
mysqldump -uroot -predhat –add-drop-table –no-data test | grep ^DROP | mysql -uroot -predhat test