dropping database tables without dropping database or finding all the table names

What level of access do you have to the database.  Command line, only through something like php etc?  The answer will depend on what access you have

I think you need like this simple mysql management tool (not like phpMyAdmin) .. download this ,  configure and upload in your shared hosting,
http://sqlbuddy.com/

so you can easily access Db tables, change, alter all are possible.

please refer these links also,

http://www.sitepoint.com/phpmyadmin-alternatives/
http://www.webdesigneronline.co.uk/10-great-alternatives-to-phpmyadmin

so you can manage your db easily

i am using mysql workbench query tool

because I have shared hosting, I can not create a database
I can do many operations (delete database, create/delete table)

If you have using shared hosting, it might be limited to create db. just ask them for more details.

also, you can get phpMyAdmin access on browser itself.

thanks for db script