APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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

XML for Analysis Schema Rowsets