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.
Important
The DISCOVER_XML_METADATA rowset cannot be queried using the SELECT command syntax. However, the DISCOVER_XML_METADATA rowset can be queried using GetSchemaDataSet()
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 Analysis Services. 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 the name/ID/timestamp/state requested for the requested objects and all descendant major objects recursively. |
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. |