DependencyTree DependencyTree DependencyTree Class


The DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.

public ref class DependencyTree : Microsoft::SqlServer::Management::Smo::DependencyTreeNode
public class DependencyTree : Microsoft.SqlServer.Management.Smo.DependencyTreeNode
Public Class DependencyTree
Inherits DependencyTreeNode




The DependencyTree object represents a SQL Server object that also references child and sibling SQL Server objects. The references to child and sibling objects are represented by DependencyTreeNode objects. The SQL Server objects that the DependencyTree object and DependencyTreeNode objects represent can be obtained using the Urn property. The DependencyTree object can be navigated using the various properties such as FirstChild and NextSibling or by using the WalkDependencies method of the DependencyWalker object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.


DependencyTree(DependencyTree) DependencyTree(DependencyTree) DependencyTree(DependencyTree)

Initializes a new instance of the DependencyTree class.


Count Count Count

Gets the total number of DependencyTreeNode objects in the DependencyTree object.

Dependencies Dependencies Dependencies

Gets or sets the collection of dependencies.

DependsOnParents DependsOnParents DependsOnParents

Gets or sets a value that indicates whether the Dependency Tree depends on parent objects.

FirstChild FirstChild FirstChild

Gets the first child DependencyTreeNode object in the DependencyTree object.

HasChildNodes HasChildNodes HasChildNodes

Gets the Boolean property value that specifies whether the DependencyTree object has any child nodes.

Index Index Index

Gets or sets the item at the given index in tree node collection.

(Inherited from DependencyTreeNode)
IsSchemaBound IsSchemaBound IsSchemaBound

Determines if the Dependency Node is bound to a schema

(Inherited from DependencyNode)
NextSibling NextSibling NextSibling

Gets the next sibling DependencyTreeNode object in the DependencyTree object.

NumberOfSiblings NumberOfSiblings NumberOfSiblings

Gets the number of sibling objects in the DependencyTree object hierarchy.

Roots Roots Roots

Gets or sets the collection of root nodes.

Siblings Siblings Siblings

Gets or sets the siblings contained in a dependency tree node.

(Inherited from DependencyTreeNode)
Urn Urn Urn

Gets the Urn value of that uniquely identifies the SQL Server object that the DependencyTree object represents.


Copy() Copy() Copy()

Makes a copy of the DependencyTree object.

Remove(DependencyTreeNode) Remove(DependencyTreeNode) Remove(DependencyTreeNode)

Removes a DependencyTreeNode object from the DependencyTree object.

Applies to