[Ref]SQLDMO QueryResults

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.