show [AS JSON] namespaces 

Shows a list of all namespaces in the system.

For example:

sql-> show namespaces
namespaces
  ns1
  sysdefault
sql-> show as json namespaces
{"namespaces" : ["ns1","sysdefault"]}