Graph functions (Transact-SQL)

Applies to: SQL Server 2017 (14.x) and later Azure SQL Database Azure SQL Managed Instance

Use the functions described on the pages in this section to extract values from, and transform values to, the pseudo-columns used in SQL Graph.

Function	Description
EDGE_ID_FROM_PARTS	Construct an `edge_id` from `object_id` and `graph_id`
GRAPH_ID_FROM_EDGE_ID	Extract the `graph_id` from a `edge_id`
GRAPH_ID_FROM_NODE_ID	Extract the `graph_id` from a `node_id`
NODE_ID_FROM_PARTS	Construct a `node_id` from an `object_id` and a `graph_id`
OBJECT_ID_FROM_EDGE_ID	Extract the `object_id` from an `edge_id`
OBJECT_ID_FROM_NODE_ID	Extract the `object_id` from a `node_id`

Next steps