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.
.gif "ms126290.note(en-US,SQL.90).gif")
Note:
Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.
See Also
Reference
OLE DB for OLAP Schema Rowsets