SQLDMO를 사용하다 보면 특정 method의 결과가 QueryResults인 경우가 있다.
QueryResult는 다음과 같이 구성된다.
..more
>접기
A QueryResults object that contains up to three result sets. When no user-defined data types, defaults, or rules are contained in the dependency tree, a single result set is returned, defined by these columns.
| Column | Data type | Description |
|---|
| oObjName | nvarchar(129) | Database object name. |
| oOwner | nvarchar(129) | Database object owner name. |
| oSequence | smallint | Indicator of distance in the hierarchy between the specified object and the object listed. |
| oType | integer | Database object type, enumerated by SQLDMO_OBJECT_TYPE. |
| RelName | nvarchar(129) | Displayed when SQLDMODep_FullHierarchy is specified. Hierarchically-related database object name. |
| RelOwner | nvarchar(129) | Displayed when SQLDMODep_FullHierarchy is specified. Hierarchically-related database object owner name. |
| RelType | integer | Displayed when SQLDMODep_FullHierarchy is specified. When the RelName value is nonNULL, RelType is the hierarchically related database object type, enumerated by SQLDMO_OBJECT_TYPE. When RelName value is NULL, the value 0 is returned and can be ignored. |
When the dependency tree contains defaults, rules, or user-defined data types, one or two additional result sets are returned by the EnumDependencies method. When rules or defaults are contained, a result set is returned, defined by these columns.
| Column | Data type | Description |
|---|
| oOwner | nvarchar(129) | Database object owner name. |
| oRuleDefName | nvarchar(129) | Database object name. |
| oSequence | smallint | Indicator of distance in the hierarchy between the specified object and the object listed. |
| oType | integer | Database object type, enumerated by SQLDMO_OBJECT_TYPE. Value is SQLDMOObj_Default or SQLDMOObj_Rule for all rows. |
When user-defined data types are contained in the dependency tree, a result set that enumerates the data types is returned. The user-defined data type result set is defined by these columns.
| Column | Data type | Description |
|---|
| oType | integer | Database object type, enumerated by SQLDMO_OBJECT_TYPE. Value is SQLDMOObj_UserDefinedDatatype for all rows. |
| oUDDTName | nvarchar(129) | User-defined data type name. |
| oOwner | nvarchar(129) | User-defined data type owner name. |
| oSequence | smallint | Indicator of distance in the hierarchy between the specified object and the object listed. |