Namespace Commands

Namespaces provide logical grouping for tables, similar to schemas in other databases.

CREATE NAMESPACE

SQL

1CREATE NAMESPACE <namespace_name>;2CREATE NAMESPACE IF NOT EXISTS <namespace_name>;

Example:

SQL

1CREATE NAMESPACE IF NOT EXISTS chat;2CREATE NAMESPACE IF NOT EXISTS analytics;

DROP NAMESPACE

SQL

1DROP NAMESPACE <namespace_name>;2DROP NAMESPACE IF EXISTS <namespace_name>;3DROP NAMESPACE <namespace_name> CASCADE;4DROP NAMESPACE IF EXISTS <namespace_name> CASCADE;

The CASCADE option drops all tables within the namespace.

Example:

SQL

1-- Drop only if empty2DROP NAMESPACE analytics;3 4-- Drop with all contained tables5DROP NAMESPACE IF EXISTS analytics CASCADE;

ALTER NAMESPACE

SQL

1ALTER NAMESPACE <namespace_name>2  SET DESCRIPTION '<description>';

Example:

SQL

1ALTER NAMESPACE chat2  SET DESCRIPTION 'Chat application tables';

USE / SET NAMESPACE

Set the default namespace for the current request or multi-statement batch:

SQL

1USE <namespace_name>;2USE NAMESPACE <namespace_name>;3SET NAMESPACE <namespace_name>;

In the interactive CLI, a successful USE also updates the CLI’s local namespace so later requests automatically send namespace_id.

Example:

SQL

1USE chat;2 3-- Now you can reference tables without the namespace prefix4SELECT * FROM messages;

SHOW NAMESPACES

List all available namespaces:

SQL

1SHOW NAMESPACES;