Share via


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

Help and Information

Getting SQL Server 2005 Assistance