Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DISCOVER_SCHEMA_ROWSETS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

The DISCOVER_SCHEMA_ROWSETS rowset contains the following columns.

Column name

Type indicator

Length

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>

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

Community Additions

ADD
Show:
© 2015 Microsoft