DISCOVER_PROPERTIES Rowset
Returns a list of information and values about the standard and provider-specific properties that are supported by the Microsoft XML for Analysis (XMLA) provider for the specified data source. Unsupported properties are not listed in the returned result set.
If you call the Discover method with the DISCOVER_PROPERTIES enumeration value in the RequestType element, the Discover method returns the DISCOVER_PROPERTIES rowset..
Rowset Columns
The DISCOVER_PROPERTIES rowset contains the following columns.
| Column name | Type | Length | Description |
|---|---|---|---|
PropertyName |
DBTYPE_WSTR |
The name of the property. |
|
PropertyDescription |
DBTYPE_WSTR |
A localizable text description of the property. May return NULL. |
|
PropertyType |
DBTYPE_WSTR |
The XML data type of the property. May return NULL. |
|
PropertyAccessType |
DBTYPE_WSTR |
The access for the property. The value can be Read, Write, or ReadWrite. |
|
IsRequired |
DBTYPE_BOOL |
A Boolean that indicates whether a property is required. True if a property is required; false if it is not required. May return NULL. |
|
Value |
DBTYPE_WSTR |
The current value of the property. May return NULL. |
This schema rowset is not sorted.
Restriction Columns
The DISCOVER_PROPERTIES rowset can be restricted on the column listed in the following table.
| Column name | Type indicator | Restriction State |
|---|---|---|
PropertyName |
DBTYPE_WSTR |
See Also
Reference
XML for Analysis Schema Rowsets