MDSCHEMA_SETS Rowset
Describes any sets that are currently defined in a database, including session-scoped sets.
Rowset Columns
The MDSCHEMA_SETS rowset contains the following columns.
Column name | Type indicator | Length | Description |
---|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
The name of the database. |
|
SCHEMA_NAME |
DBTYPE_WSTR |
Not supported. |
|
CUBE_NAME |
DBTYPE_WSTR |
The name of the cube. |
|
SET_NAME |
DBTYPE_WSTR |
The name of the set, as specified in the CREATE SET statement. |
|
SCOPE |
DBTYPE_I4 |
The scope of the set:
|
|
DESCRIPTION |
DBTYPE_WSTR |
Not supported. |
|
EXPRESSION |
DBTYPE_WSTR |
The expression for the set. |
|
DIMENSIONS |
DBTYPE_WSTR |
A comma delimited list of hierarchies included in the set. |
|
SET_CAPTION |
DBTYPE_WSTR |
A label or caption associated with the set. The label or caption is used primarily for display purposes. |
|
SET_DISPLAY_FOLDER |
DBTYPE_WSTR |
The path to be used by the user interface when displaying the set. Folder names are separated by a backslash (\), folders are separated by a semicolon (;). |
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME.
Restriction Columns
The MDSCHEMA_SETS rowset can be restricted on the columns listed in the following table.
Column name
Type indicator
Restriction State
CATALOG_NAME
DBTYPE_WSTR
Optional.
SCHEMA_NAME
DBTYPE_WSTR
Optional.
CUBE_NAME
DBTYPE_WSTR
Optional.
SET_NAME
DBTYPE_WSTR
Optional.
SCOPE
DBTYPE_I4
Optional.
HIERARCHY_UNIQUE_NAME
DBTYPE_WSTR
Optional.
CUBE_SOURCE
DBTYPE_UI2
Optional.
Примечание.
Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.
См. также
Справочник
OLE DB for OLAP Schema Rowsets