MDSCHEMA_PROPERTIES

Analysis Services Programming

Analysis Services Programming

MDSCHEMA_PROPERTIES

This schema rowset describes the properties of members contained in a database.

Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following column to this schema rowset.

Column name Type Description
PROPERTY_CONTENT_TYPE DBTYPE_I2 Property type
Restriction Columns

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
DIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
LEVEL_UNIQUE_NAME
MEMBER_UNIQUE_NAME
PROPERTY_NAME
PROPERTY_TYPE

For more information about the MDSCHEMA_PROPERTIES schema rowset, see the OLE DB documentation.