SETS Rowset

  • Article

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.