• There isn't a great reference out there, and apologies for not getting a better one. The HierarchyID, from what I've seen from various sources, is a binary representation of a hierarchy, and it's implemented as a CLR type. The ToString() method will return a string representation with slashes, but the type itself is essentially a UDT, that's built into the system.