Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The HierarchyId property is used to identify a position in a hierarchy.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Shared ReadOnly Property HierarchyId As DataType
Get
'Usage
Dim value As DataType
value = DataType.HierarchyId
public static DataType HierarchyId { get; }
public:
static property DataType^ HierarchyId {
DataType^ get ();
}
static member HierarchyId : DataType
static function get HierarchyId () : DataType
Property Value
Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a HierarchyId definition in the data type.
Remarks
Use HierarchyId to query and perform operations on hierarchical data.
Examples
Visual Basic
Dim dt As DataType
dt = New DataType(SqlDataType.HierarchyId)
PowerShell
$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::HierarchyId)