SETS Rowset
The SETS rowset contains information about the sets in a schema (or the catalog, if the provider does not support schemas). It has the structure described in the following table.
The default sort order is CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.
| Column name |
Type indicator |
Description |
| CATALOG_NAME |
DBTYPE_WSTR |
Name of the catalog to which the set belongs. NULL if the provider does not support catalogs. |
| SCHEMA_NAME |
DBTYPE_WSTR |
The name of the schema to which the dimension belongs. NULL if the provider does not support schemas. |
| CUBE_NAME |
DBTYPE_WSTR |
Name of the cube to which the set belongs. Cannot be NULL. |
| SET_NAME |
DBTYPE_WSTR |
The name of the set, as specified in the CREATE SET statement. |
| SCOPE |
DBTYPE_I4 |
The scope of the set. One of the following:
- MDSET_SCOPE_GLOBAL
- MDSET_SCOPE_SESSION
|
| DESCRIPTION |
DBTYPE_WSTR |
Optional. A human-readable description of the set. |
