Share via


Summary: Converting a Table to a Hierarchical Structure

The hierarchyid data type can store a hierarchical relationship in a simple, compact format. Proper indexes can efficiently return data by the level of the hierarchy, by sub-trees of the hierarchy, or by traditional singleton lookups.

In this lesson, you used two of the hierarchical methods. The next lesson will demonstrate how to use more of these methods to query and manipulate the hierarchical data.

Next Lesson

Lesson 2: Creating and Managing Data in a Hierarchical Table

See Also

Concepts

Hierarchical Data (SQL Server)