DROP NAMESPACE
Eon Mode only
Drops a namespace from an Eon Mode database. Unless you specify the CASCADE option, the statement errors if there are any schemata or tables in the namespace. If CASCADE is specified, the namespace and its member tables and schemata are all dropped.
Syntax
DROP NAMESPACE [ IF EXISTS ] name [ CASCADE ]
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. CASCADE- Drops all objects contained in the namespace.
Privileges
Superuser
Examples
Drop the analytics namespace, including any objects it contains:
=> DROP NAMESAPCE `analytics` CASCADE;
DROP NAMESPACE