5.6 Selecting All Properties in the COLUMNS Clause

You can select all the vertex or edge properties based on the element type (vertex or edge) and any label expression specified for the element in the COLUMNS clause of a SQL graph query.

The set of properties is the union of properties of the vertex (or edge) labels belonging to tables that have at least one label that satisfies the label expression. In case some of these matching tables define a property while other tables do not, then NULL values will be returned for those tables that do not define the property.

For instance, the following example matches all the vertices in the graph g and retrieves all the valid properties through n.* in the COLUMNS clause.

SELECT *
FROM GRAPH_TABLE ( g
  MATCH (n IS person) 
  COLUMNS ( n.* )
)

See Example 5-23 for more information.