This topic has not yet been rated - Rate this topic

DISCOVER_SCHEMA_ROWSETS Rowset

SQL Server 2008

Returns the names, restrictions, description, and other information for all enumeration values and any additional provider-specific enumeration values supported by the Microsoft XML for Analysis (XMLA) provider.

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

Rowset Columns

The DISCOVER_SCHEMA_ROWSETS rowset contains the following columns.

Column name	Type indicator	Description
SchemaName	DBTYPE_WSTR	The name of the schema or request. This request returns the values in the RequestTypes enumeration.
SchemaGuid	DBTYPE_GUID	The GUID of the schema.
Restrictions	DBTYPE_HCHAPTER	An array of the restrictions supported by the provider.
Description	DBTYPE_WSTR	A localizable description of the schema.
RestrictionsMask	DBTYPE_UI8

This schema rowset is not sorted.

For a provider that supports three restrictions for the DBSCHEMA_MEMBERS schema rowset, the Restrictions array might return the following result. The elements in the result refer to column names in the schema.

<Restrictions>
      <CATALOG_NAME type="string" /> 
      <SCHEMA_NAME type="string" /> 
      <CUBE_NAME type="string" /> 
</Restrictions>

Restriction Columns

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

Column name	Type indicator	Restriction State
SchemaName	DBTYPE_WSTR

Reference

XML for Analysis Schema Rowsets

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD