Is there an easy way to delete multiple tables in the database without dropping the database and recreating it? In this case we have over 100 to remove.

I am happy enough to remove *all* user tables and reimport the needed data but can't touch any of the database security settings.