DependencyWalker Class
The DependencyWalker object is a tool to perform scripting operations that involve dependencies such as identifying dependent relationships. The tool and converts this output to a list.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.DependencyWalker
Microsoft.SqlServer.Management.Smo.Scripter
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Class DependencyWalker
'Usage
Dim instance As DependencyWalker
public class DependencyWalker
public ref class DependencyWalker
type DependencyWalker = class end
public class DependencyWalker
The DependencyWalker type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
DependencyWalker() | Initializes a new instance of the DependencyWalker class. |
|
DependencyWalker(Server) | Initializes a new instance of the DependencyWalker class on the specified instance of SQL Server. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Protected property") |
DependencyTree | Gets or sets a server dependency tree. |
.gif "Public property") |
FilterCallbackFunction | Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method. |
|
KnownObjectsList | Gets or sets a list of all known objects in a server. |
|
Server | Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with. |
|
Total | Gets or sets the number of objects that have been processed by the DependencyWalker object. |
|
TotalCount | Gets or sets the count of objects discovered by a dependency walker. |
Top
Methods
| Name | Description | |
|---|---|---|
|
DiscoverDependencies(array<SqlSmoObject[], DependencyType) | Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server. |
|
DiscoverDependencies(array<SqlSmoObject[], Boolean) | Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server. |
|
DiscoverDependencies(array<Urn[], DependencyType) | Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server. |
|
DiscoverDependencies(array<Urn[], Boolean) | Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server. |
|
DiscoverDependencies(UrnCollection, DependencyType) | Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server. |
|
DiscoverDependencies(UrnCollection, Boolean) | Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server. |
|
Equals | (Inherited from Object.) |
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
GetHashCode | (Inherited from Object.) |
|
GetServerObject | Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running. |
|
GetType | (Inherited from Object.) |
|
MemberwiseClone | (Inherited from Object.) |
|
ToString | (Inherited from Object.) |
|
WalkDependencies | Creates a linear list of objects and their dependencies from a specified DependencyTree object. |
Top
Events
| Name | Description | |
|---|---|---|
.gif "Public event") |
DiscoveryProgress | Raises an event at intervals and reports progress on the DiscoveryProgress method. |
Top
Remarks
The DependencyWalker object does not represent any physical SQL Server 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.
Examples
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.