SQL-J Language Reference
Page 25 of 121

DROP SCHEMA statement

The DROP SCHEMA statement drops a schema. The target schema must be empty for the drop to succeed.

Neither the APP schema (the default user schema) nor the SYS schema can be dropped. If the current schema is dropped and it is the user's default schema, the user's default schema is set to APP.

Syntax

DROP SCHEMA SchemaName

Example

-- Drop the hotel schema
DROP SCHEMA hotel