|Statements / DROP statements|
Drop the specified empty schema.
DROP SCHEMA [ IF EXISTS ] schema-name RESTRICT
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.
DROP SCHEMA EMP RESTRICT;
The EMP schema may only be deleted from the database if no objects are defined in the EMP schema.