If this is a situation where all the tables you want to drop are in the same schema, then you can simply drop the schema if you'd rather not write out every table name

DROP SCHEMA my_database.my_schema CASCADE