SHOW GRAPHS command

The SHOW GRAPHS command returns information about all graphs in the schema of the current session and all temporary graphs in the catalog.

To list persistent graphs, the current user must have USAGE on the schema of the current session. If the privilege is missing, the command returns an insufficient privilege error. Schema USAGE does not change the existing access rules for temporary graphs. For more information, see Schema access control.

The following table describes the returned information:

Column	Description
name	The name of the graph or temporary graph.
graph_type	The graph type based on which the graph or temporary graph is created.
schema	The path of the schema where the graph or temporary graph is located.
owner	The owner of the graph or temporary graph.
extra	Additional information. For graphs, no additional information is provided. For temporary graphs, the value indicates whether the temporary graph is created in distributed mode. For more information, see CREATE TEMPORARY GRAPH.

Syntax

diagramsource

show_graphs_command

show_graphs_command ::=
    'SHOW' 'GRAPHS'

Examples

The following examples are based on the example dataset.

Show all graphs and temporary graphs

SHOW GRAPHS

Return:

+------------------------+--------------------------+-----------------+-------+-------------------+
| name                   | graph_type               | schema          | owner | extra             |
+------------------------+--------------------------+-----------------+-------+-------------------+
| movie                  | movie_type               | /default_schema | root  |                   |
| #sub_movie_temp        | movie_type               | /tmp_schema     | root  | distributed:false |
| #movie_temporary_graph | movie_type               | /tmp_schema     | root  | distributed:false |
+------------------------+--------------------------+-----------------+-------+-------------------+