4
DROP SCHEMA removes all tables and related objects from a schema once all queries or DML have ceased
5
on them. It then removes the schema itself from the catalog that owned it.
7
DROP SCHEMA schema_name
9
Most storage engines do not have transactional DDL that is isolated from
10
other transactions, so the incomplete effects of DROP SCHEMA will be viewable by