HANA: How to drop schema

Syntax

 DROP SCHEMA <schema_name> [<drop_option>]

Syntax Elements

 <drop_option> ::= CASCADE | RESTRICT

When <drop_option> is not specified a non-cascaded drop will be performed. This will only drop the specified schema, dependent objects of the schema will be invalidated but not dropped.

The invalidated object can be revalidated when an object that has same schema name is created.

 CASCADE

Drops the schema and dependent objects.

 RESTRICT

Drops the schema only when dependent objects do not exist. If this drop option is used and a dependent object exists an error will be thrown.

Description

The DROP SCHEMA statement removes a schema.

Example

You create schema my_schema and a table my_schema.t.

 CREATE SCHEMA my_schema;
 CREATE TABLE my_schema.t (a INT);

You drop my_schema with a CASCADE option.

 DROP SCHEMA my_schema CASCADE;

Source: http://sap.optimieren.de/hana/hana/html/sql_drop_schema.html