SETS Schema Rowset

Standard Mapping

The SETS rowset returns metadata about the sets that are available on each schema or catalog that can be accessed by the provider. Each row in the SETS schema rowset corresponds to one set that is available in the provider. The default sort order is CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, SET_NAME.
The following table describes the columns that are available in the SETS schema rowset.
Standard Mapping
Column Name
Type Indicator
Mapped Value
Restrictions Supported?
CATALOG_NAME
DBTYPE_WSTR
Name of the catalog to which the set belongs.
Yes
SCHEMA_NAME
DBTYPE_WSTR
Name of the schema that contains this set.
Yes
CUBE_NAME
DBTYPE_WSTR
Name of the cube that contains this set.
Yes
SET_NAME
DBTYPE_WSTR
Name of the set.
Yes
SCOPE
DBTYPE_14
Scope of the set. One of the following types:
  • MDSET_SCOPE_GLOBAL
  • MDSET_SCOPE_SESSION
Yes
DESCRIPTION
DBTYPE_WSTR
Description of this set.
No
Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.