Table structure used when converting between either a JSON string or an XML Value, and its equivalent tabular representation.

  • Table
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
Column name Data type Description
RowID int Auto-generated unique ID
ParentRowID int Parent RowID, if any.
NodePath nvarchar(MAX) Path to current position in the Json string or the XML Value. Note that this path is similar to XPath but square brackets were replaced with curly brackets in order to simplify using this value in a WHERE clause
NodeType nvarchar(50) Object, Array, String, Number or Boolean
Name nvarchar(500) Key name
Value nvarchar(MAX) Key Value


This table is associated with the following stored procedures:

See Also: