Neoview SQL Reference Manual (R2.2)

DROP SCHEMA Statement
• “Syntax Description of DROP SCHEMA”
• “Considerations for DROP SCHEMA”
• “Example of DROP SCHEMA”
The DROP SCHEMA statement deletes a Neoview SQL schema. See“Schemas” (page 247).
DROP SCHEMA schema
Syntax Description of DROP SCHEMA
schema
is the name of the schema to drop.
Considerations for DROP SCHEMA
Authorization and Availability Requirements
To drop a schema, you must own the schema.
Example of DROP SCHEMA
• This example drops an empty schema:
DROP SCHEMA sales;
96 SQL Statements