DROP SCHEMA

Use the DROP SCHEMA statement to drop existing schemas.

Usage

DROP SCHEMA schema-name {CASCADE | RESTRICT}

Notes

SYS is the only person who can drop any schema on the Kognitio. Other users can only issue the DROP SCHEMA command for a schema that they own.

The RESTRICT keyword limits the command, so that it only drops schemas that are empty.

The CASCADE keyword drops all database objects in the specified schema, and any referenced in other schemas before dropping the schema itself.