Share via


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:

  • MDSET_SCOPE_GLOBAL (1)
  • MDSET_SCOPE_SESSION (2)

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.

ms126290.note(en-US,SQL.90).gifNote:

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

Help and Information

Getting SQL Server 2005 Assistance