List composite databases
You can list composite databases using the command SHOW DATABASES
.
Composite databases are listed with the type composite
in the type
column of the result set.
Query
SHOW DATABASES
Result
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | name | type | aliases | access | address | role | writer | requestedStatus | currentStatus | statusMessage | default | home | constituents | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | "library" | "composite" | [] | "read-only" | "localhost:7687" | NULL | FALSE | "online" | "online" | "" | FALSE | FALSE | ["library.sci-fi"] | | "neo4j" | "standard" | [] | "read-write" | "localhost:7687" | "primary" | TRUE | "online" | "online" | "" | TRUE | TRUE | [] | | "sci-fi" | "standard" | ["library.sci-fi"] | "read-write" | "localhost:7687" | "primary" | TRUE | "online" | "online" | "" | FALSE | FALSE | [] | | "system" | "system" | [] | "read-write" | "localhost:7687" | "primary" | TRUE | "online" | "online" | "" | FALSE | FALSE | [] | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
For a description of all the returned columns of this command, ways in which the SHOW DATABASE
command can be filtered, and details about the privileges required for the command, see List standard databases.
For composite databases, the constituents
column is particularly interesting as it lists the aliases that make up the composite database.
Query
SHOW DATABASE library YIELD name, constituents
Result
+--------------------------------+ | name | constituents | +--------------------------------+ | "library" | ["library.sci-fi"] | +--------------------------------+