Compartir a través de


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(es-es,SQL.90).gifNota:

Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.

Vea también

Referencia

OLE DB for OLAP Schema Rowsets

Ayuda e información

Obtener ayuda sobre SQL Server 2005