DISCOVER_SCHEMA_ROWSETS Rowset
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 | 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>
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 |
See Also
Reference
XML for Analysis Schema Rowsets