How to drop tables shown as Missing in Schema Report
Check out the db_drop_table function.

You could use it on the mysite.com/devel/php page which runs arbitrary php for you, but be ultra careful with it and always have backups, because if you get it wrong you could completely kill your site.