MDSCHEMA_PROPERTIES Rowset
Describes the properties of members within a database.
Rowset Columns
The MDSCHEMA_PROPERTIES rowset contains the following columns.
| Column name | Type indicator | Length | Description |
|---|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
The name of the database. |
|
SCHEMA_NAME |
DBTYPE_WSTR |
The name of the schema to which this property belongs. NULL if the provider does not support schemas. |
|
CUBE_NAME |
DBTYPE_WSTR |
The name of the cube. |
|
DIMENSION_UNIQUE_NAME |
DBTYPE_WSTR |
The unique name of the dimension. For providers that generate unique names by qualification, each component of this name is delimited. |
|
HIERARCHY_UNIQUE_NAME |
DBTYPE_WSTR |
The unique name of the hierarchy. For providers that generate unique names by qualification, each component of this name is delimited. |
|
LEVEL_UNIQUE_NAME |
DBTYPE_WSTR |
The unique name of the level to which this property belongs. If the provider does not support named levels, it should return the DIMENSION_UNIQUE_NAME value for this field. For providers that generate unique names by qualification, each component of this name is delimited. |
|
MEMBER_UNIQUE_NAME |
DBTYPE_WSTR |
The unique name of the member to which the property belongs. Used for data stores that do not support named levels or have properties on a member-by-member basis. If the property applies to all members in a level, this column is NULL. For providers that generate unique names by qualification, each component of this name is delimited. |
|
PROPERTY_TYPE |
DBTYPE_I2 |
A bitmap that specifies the type of the property:
|
|
PROPERTY_NAME |
DBTYPE_WSTR |
The name of the property. If the key for the property is the same as the name for the property, PROPERTY_NAME will be blank. |
|
PROPERTY_CAPTION |
DBTYPE_WSTR |
A label or caption associated with the property, used primarily for display purposes. Returns PROPERTY_NAME if a caption does not exist. |
|
DATA_TYPE |
DBTYPE_UI2 |
The data type of the property. |
|
CHARACTER_MAXIMUM_LENGTH |
DBTYPE_UI4 |
The maximum possible length of the property, if it is a character, binary, or bit type. Zero indicates there is no defined maximum length. Returns NULL for all other data types. |
|
CHARACTER_OCTET_LENGTH |
DBTYPE_UI4 |
The maximum possible length (in bytes) of the property, if it is a character or binary type. Zero indicates there is no defined maximum length. Returns NULL for all other data types. |
|
NUMERIC_PRECISION |
DBTYPE_UI2 |
The maximum precision of the property, if it is a numeric data type. Returns NULL for all other data types. |
|
NUMERIC_SCALE |
DBTYPE_I2 |
The number of digits to the right of the decimal point, if it is a DBTYPE_NUMERIC or DBTYPE_DECIMAL type. Returns NULL for all other data types. |
|
DESCRIPTION |
DBTYPE_WSTR |
A human readable description of the property. NULL if no description exists. |
|
PROPERTY_CONTENT_TYPE |
DBTYPE_I2 |
The type of the property. Can be one of the following enumerations:
|
|
SQL_COLUMN_NAME |
DBTYPE_WSTR |
The name of the property used in SQL queries from the cube dimension or database dDimension. |
|
LANGUAGE |
DBTYPE_UI2 |
The translation expressed as an LCID. Only valid for property translations. |
|
PROPERTY_ORIGIN |
DBTYPE_UI2 |
Identifies the type of hierarchy that the property applies to:
|
|
PROPERTY_ATTRIBUTE_HIERARCHY_NAME |
DBTYPE_WSTR |
The name of the attribute hierarchy sourcing this property. |
|
PROPERTY_CARDINALITY |
DBTYPE_WSTR |
The cardinality of the property. Possible values include the following strings:
|
|
MIME_TYPE |
DBTYPE_WSTR |
The mime type for binary large objects (BLOBs). |
|
PROPERTY_IS_VISIBLE |
DBTYPE_BOOL |
A Boolean that indicates whether the property is visible. TRUE if the property is visible; otherwise, FALSE. |
This schema rowset is not sorted.
Restriction Columns
The MDSCHEMA_PROPERTIES rowset can be restricted on the columns listed in the following table.
| Column name | Type indicator | Restriction State |
|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
Mandatory |
SCHEMA_NAME |
DBTYPE_WSTR |
Optional |
CUBE_NAME |
DBTYPE_WSTR |
Optional |
DIMENSION_UNIQUE_NAME |
DBTYPE_WSTR |
Optional |
HIERARCHY_UNIQUE_NAME |
DBTYPE_WSTR |
Optional |
LEVEL_UNIQUE_NAME |
DBTYPE_WSTR |
Optional |
MEMBER_UNIQUE_NAME |
DBTYPE_WSTR |
Optional |
PROPERTY_NAME |
DBTYPE_WSTR |
Optional |
PROPERTY_TYPE |
DBTYPE_I2 |
Optional |
PROPERTY_CONTENT_TYPE |
DBTYPE_I2 |
(Optional) A default restriction is in place on MDPROP_MEMBER OR MDPROP_CELL. |
PROPERTY_ORIGIN |
DBTYPE_UI2 |
(Optional) A default restriction is in place on MD_USER_DEFINED OR MD_SYSTEM_ENABLED |
CUBE_SOURCE |
DBTYPE_UI2 |
(Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
PROPERTY_VISIBILITY |
DBTYPE_UI2 |
(Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
Voir aussi
Référence
OLE DB for OLAP Schema Rowsets