DROP NAMESPACE

On this page

The DROP NAMESPACE command allows you to delete a namespace, including all entities within this namespace. This statement can also used to delete non-relational namespaces.

Syntax

The basic syntax for a DROP NAMESPACE statement in Polypheny is:

DROP (NAMESPACE|SCHEMA) [IF EXISTS] namespace_name

Parameters

  • NAMESPACE or SCHEMA: These keywords are interchangeable and used to specify that a namespace should be dropped.
  • IF EXISTS: This is an optional clause. If the IF EXISTS clause is included, the statement will not return an error if the specified namespace does not exist. If the IF EXISTS clause is not included and the specified namespace does not exist, the statement will result in an error.
  • namespace_name: The name of the namespace to be dropped.

Example

Here is an example of a DROP NAMESPACE statement:

DROP NAMESPACE IF EXISTS my_namespace

This example deletes the namespace my_namespace if it exists.

Be careful when using this statement, as it will permanently remove the namespace and all its contents. You cannot undo this operation.
© Polypheny GmbH. All Rights Reserved.