← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/drop_schema.rst

  • Committer: Marisa Plumb
  • Date: 2010-11-30 00:28:02 UTC
  • mto: This revision was merged to the branch mainline in revision 1984.
  • Revision ID: marisa.plumb@gmail.com-20101130002802-vapha1qp5giia1s7
edits and basic rewrites to the introduction docs

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/drop_schema.rst
1
1
DROP SCHEMA
2
2
============
3
3
 
4
 
DROP SCHEMA drops all tables and related objects in a schema and deletes it. It only does this once all queries or DML have ceased on them. At this point, it removes the schema itself from the catalog that owned it.
5
 
 
6
 
Syntax: ::
7
 
 
8
 
        DROP SCHEMA schema_name
9
 
 
10
 
Most storage engines do not have transactional DDL that is isolated from other transactions, so the incomplete effects of DROP SCHEMA will be viewable by other transactions.
 
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