DROP SCHEMA

Drop the specified empty schema.

Syntax

DROP SCHEMA [ IF EXISTS ] schema-name RESTRICT

Description

Include the IF EXISTS clause to execute the statement only if the specified schema exists in GemFire XD. The RESTRICT keyword enforces the rule that no objects can be defined in the specified schema for the schema to be deleted from the database. The RESTRICT keyword is required, as GemFire XD cannot drop a schema that contains database objects.

Example

DROP SCHEMA EMP RESTRICT;

The EMP schema may only be deleted from the database if no objects are defined in the EMP schema.