CREATE NAMESPACE Statement

You can add a new namespace by using the CREATE NAMESPACE statement.

Syntax

create_namespace_statement ::= 
   CREATE NAMESPACE [IF NOT EXISTS] namespace_name

namespace_name ::= name_path
name_path ::= field_name ("." field_name)*
field_name ::= id | DSTRING

Semantics

IF NOT EXISTS: This is an optional clause. If you specify this clause, and if a namespace with the same name exists, then this is a noop and no error is generated. If you don't specify this clause, and if a namespace with the same name exists, an error is generated indicating that the namespace already exists.

Note:

Namespace names starting with sys are reserved. You cannot use the prefix sys for any namespaces.

Example 3-1 Create Namespace Statement

The following statement defines a namespace named ns1.

CREATE NAMESPACE IF NOT EXISTS ns1;