SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

DataType.HierarchyId Property

SQL Server 2012

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)
C#
C++
F#
JScript
VB
Copy 
public static DataType HierarchyId { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a HierarchyId definition in the data type.

Use HierarchyId to query and perform operations on hierarchical data.

Visual Basic

Copy 
Dim dt As DataType
dt = New DataType(SqlDataType.HierarchyId)

PowerShell

Copy 
$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::HierarchyId)
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.