DROP SCHEMA - Kinetica Docs

Removes an existing schema.

DROP SCHEMA Syntax

DROP SCHEMA [IF EXISTS] <schema name> [CASCADE]

Parameters

IF EXISTS

Optional error-suppression clause; if specified, no error will be returned if the given schema does not exist

Name of the schema to remove

CASCADE

Drops all objects contained within the schema; if not specified, an error will be returned if the given schema contains any tables, views, etc.

To drop a schema, including all contained objects:

DROP SCHEMA Example

DROP SCHEMA example_container CASCADE

⌘I