1. SQL Reference Guide
  2. Namespace Management
  3. SHOW NAMESPACES Statement

SHOW NAMESPACES Statement

Syntax

show_namespaces_statement ::= SHOW [AS JSON] NAMESPACES

Semantics

The show namespaces statement provides the list of namespaces in the system.

AS JSON can be specified if you want the output to be in JSON format.

Example 3-2 Show Namespaces

The following statement lists the namespaces present in the system.

SHOW NAMESPACES
Output:

 namespaces
  ns1
  sysdefault

Example 3-3 Show Namespaces

The following statement lists the namespaces present in the system in JSON format.

SHOW AS JSON NAMESPACES
Output:
{"namespaces" : ["ns1","sysdefault"]}