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
orSCHEMA
: These keywords are interchangeable and used to specify that a namespace should be dropped.IF EXISTS
: This is an optional clause. If theIF EXISTS
clause is included, the statement will not return an error if the specified namespace does not exist. If theIF 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.