Graph functions (Transact-SQL)

Applies to: SQL Server 2017 (14.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

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

• SQL Graph Architecture
• SQL Graph Database Sample