Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_24.2/page/index.html

DROP NAMESPACE

Eon Mode only

Drops a namespace from an Eon Mode database. The statement errors if there are any schemata or tables in the namespace.

Syntax

DROP NAMESPACE [ IF EXISTS ] name

Arguments

IF EXISTS
Do not report an error if the namespace does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
name
Name of the namespace to drop. You cannot drop the default_namespace.

Privileges

Superuser

Examples

Drop the analytics namespace:

=> DROP NAMESAPCE `analytics`;
DROP NAMESPACE 

See also