DISCOVER_XML_METADATA Rowset

Returns an XML document describing a requested object. The rowset that is returned always consists of one row and one column.

If you call the Discover method with the DISCOVER_XML_METATDATA enumeration value in the RequestType element, the Discover method returns the DISCOVER_XML_METATDATA rowset. .

Rowset Columns

The DISCOVER_XML_METADATA rowset contains the following column.

Column name Type indicator Length Description

METADATA

DBTYPE_WSTR

An XML document that describes the object requested by the restriction.

This schema rowset is not sorted.

Restriction Columns

The DISCOVER_XML_METADATA rowset can be restricted on the columns listed in the following table.

Column name Type indicator Restriction State

DatabaseID

DBTYPE_WSTR

Optional.

DimensionID

DBTYPE_WSTR

Optional.

CubeID

DBTYPE_WSTR

Optional.

MeasureGroupID

DBTYPE_WSTR

Optional.

PartitionID

DBTYPE_WSTR

Optional.

PerspectiveID

DBTYPE_WSTR

Optional.

DimensionPermissionID

DBTYPE_WSTR

Optional.

RoleID

DBTYPE_WSTR

Optional.

DatabasePermissionID

DBTYPE_WSTR

Optional.

MiningModelID

DBTYPE_WSTR

Optional.

MiningModelPermissionID

DBTYPE_WSTR

Optional.

DataSourceID

DBTYPE_WSTR

Optional.

MiningStructureID

DBTYPE_WSTR

Optional.

AggregationDesignID

DBTYPE_WSTR

Optional.

TraceID

DBTYPE_WSTR

Optional.

MiningStructurePermissionID

DBTYPE_WSTR

Optional.

CubePermissionID

DBTYPE_WSTR

Optional.

AssemblyID

DBTYPE_WSTR

Optional.

MdxScriptID

DBTYPE_WSTR

Optional.

DataSourceViewID

DBTYPE_WSTR

Optional.

DataSourcePermissionID

DBTYPE_WSTR

Optional.

ObjectExpansion

DBTYPE_WSTR

Optional.

The restriction, ObjectExpansion, is available for every major object of Microsoft SQL Server 2005 Analysis Services (SSAS). The client typically uses restrictions to describe the OLAP objects for which the DDL is to be returned, and uses the ObjectExpansion restriction to define the degree of expansion in the returned DDL. The following table indicates whether the enumeration value is allowed for Alter Element (XMLA) commands.

Enumeration Value Description

ReferenceOnly

Returns only name/ID/timestamp/state for the requested.

ObjectProperties

Expands the requested object with no references to contained objects (includes expanded minor contained objects).

ExpandObject

Same as ObjectProperties, but also returns the name, ID, and timestamp for contained major objects.

ExpandFull

Fully expands the requested object recursively to the bottom of every contained object.

请参阅

参考

XML for Analysis Schema Rowsets

帮助和信息

获取 SQL Server 2005 帮助