Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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