Applies To: SQL Server 2016 Preview
Describes any sets that are currently defined in a database, including session-scoped sets.
The MDSCHEMA_SETS rowset contains the following columns.
|Column name||Type indicator||Description|
|CATALOG_NAME||DBTYPE_WSTR||The name of the database.|
|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:|
|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||A string that identifies the path of the display folder that the client application uses to show the set. The folder level separator is defined by the client application. For the tools and clients supplied by Analysis Services, the backslash (\) is the level separator. To provide multiple display folders, use a semicolon (;) to separate the folders.|
|SET_EVALUATION_CONTEXT||DBTYPE_I4||The context for the set. The set can be static or dynamic. This column can have one of the following values:|
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME.
The MDSCHEMA_SETS rowset can be restricted on the columns listed in the following table.
|Column name||Type indicator||Restriction State|
Note: Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.