Dependency Constants (SQLDMO_DEPENDENCY_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Dependency constants control the behavior of the EnumDependencies method exposed by several SQL Distributed Management Objects (SQL-DMO) objects.
Constant |
Value |
Description |
|---|---|---|
SQLDMODep_Children |
262144 |
Lists all Microsoft SQL Server components that depend on the referenced SQL Server component. |
SQLDMODep_DRIOnly |
2097152 |
Lists only SQL Server components that depend on the referenced SQL Server component in a DRI (declarative referential integrity) relationship. |
SQLDMODep_FirstLevelOnly |
1048576 |
Lists only immediate parents. It is combined with SQLDMODep_Children to list only immediate children. |
SQLDMODep_FullHierarchy |
65536 |
Lists full parent hierarchy. It is combined with SQLDMODep_Children to list full child hierarchy. |
SQLDMODep_IncludeSystem |
4194304 |
Includes system objects. |
SQLDMODep_OrderDescending |
131072 |
Lists returned objects in descending order. |
SQLDMODep_Parents |
0 |
Lists all objects on which the referenced SQL Server component depends. |
SQLDMODep_ReturnInputObject |
524288 |
Includes the SQL Server component referenced by the SQL-DMO object in the returned list. |
SQLDMODep_Valid |
8323072 |
Combines all dependency constants by using an OR logical operator. |