"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/drop_schema.rst" (6 May 2012, 455 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

DROP SCHEMA

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.

Syntax: :

DROP SCHEMA schema_name

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.