Export (0) Print
Expand All

MDSCHEMA_MEMBERS

SQL Server 2000

MDSCHEMA_MEMBERS

This schema rowset describes the members contained in a database.

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

Column name Type indicator Description
MEMBER_KEY DBTYPE_WSTR Contains the key property for the member.
IS_PLACEHOLDERMEMBER DBTYPE_BOOL Indicates whether a member is a placeholder member for an empty position in a dimension hierarchy. It is valid only if the MDX Compatibility property has been set to 1.
IS_DATAMEMBER DBTYPE_BOOL Contains TRUE if the member is a data member.

Restriction Columns

CATALOG_NAME
SCHEMA_NAME
CUBE_NAMEDIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
IS_EMPTYMEMBER
IS_DATAMEMBER
LEVEL_UNIQUE_NAME
LEVEL_NUMBER
MEMBER_NAME
MEMBER_UNIQUE_NAME
MEMBER_CAPTION
MEMBER_TYPE
Tree operator

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

Show:
© 2014 Microsoft