|
1878.5.4
by Brian Aker
Update documentation. |
1 |
DROP SCHEMA
|
2 |
============
|
|
3 |
||
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. |
|
6 |
||
7 |
DROP SCHEMA schema_name |
|
|
1994.5.28
by Stewart Smith
add a small note about isolation of DROP SCHEMA from other txns. |
8 |
|
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 |
|
11 |
other transactions. |