SQLServer.Database.StoredProcedure Object
Lists the database objects that depend on this stored procedure, or database objects that this stored procedure depends on, in dependency order. List is returned in a QueryResults object.
QueryResults = StoredProcedure.EnumDependencies (
[[DependencyType :=] tDependency] )
HRESULT pStoredProcedure->EnumDependencies (
LPSQLOLEDBOBJECTLIST* ppQueryResults,
SQLOLE_DEPENDENCY_TYPE tDependency = SQLOLEDep_Parents );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| tDependency | SQLOLE_DEPENDENCY_TYPE | Type of dependencies to return |
This method can return up to three results sets.
| ColumnName | ColumnType |
|---|
| oType | SQLOLE_DTypeInt4 |
| oRuleDefName | SQLOLE_DTypeChar |
| oOwner | SQLOLE_DTypeChar |
| oSequence | SQLOLE_DTypeInt2 |
| ColumnName | ColumnType |
|---|
| oType | SQLOLE_DTypeInt4 |
| oUDDTName | SQLOLE_DTypeChar |
| oOwner | SQLOLE_DTypeChar |
| oSequence | SQLOLE_DTypeInt2 |
| ColumnName | ColumnType |
|---|
| oType | SQLOLE_DTypeInt4 |
| oObjName | SQLOLE_DTypeChar |
| oOwner | SQLOLE_DTypeChar |
| oSequence | SQLOLE_DTypeInt2 |