Supported schema rowsets

This table describes the different schema rowsets that are supported according to the XMLA Specification 1.1:


GUID	Number of restrictions	Restriction columns	Description
`MDSCHEMA_CUBES`	3	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME`	Contains information about the available cubes in a schema or the catalog, if the provider does not support schemas.
`MDSCHEMA_DIMENSIONS`	5	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `DIMENSION_NAME` `DIMENSION_UNIQUE_NAME`	Contains information about the dimensions in a given cube. It has one row for each dimension.
`MDSCHEMA_FUNCTIONS`	4	`LIBRARY_NAME` `INTERFACE_NAME` `FUNCTION_NAME` `RESTRICTIONS`	Contains information on the functions that are available to client applications connected to the database.
`MDSCHEMA_HIERARCHIES`	6	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `DIMENSION_UNIQUE_NAME` `HIERARCHY_NAME` `HIERARCHY_UNIQUE_NAME`	Contains information about the hierarchies available in a dimension.
`MDSCHEMA_LEVELS`	7	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `DIMENSION_UNIQUE_NAME` `HIERARCHY_UNIQUE_NAME` `LEVEL_NAME` `LEVEL_UNIQUE_NAME`	Contains information about the levels available in a dimension.
`MDSCHEMA_MEASURES`	5	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `MEASURE_NAME` `MEASURE_UNIQUE_NAME`	Contains information about the available measures.
`MDSCHEMA_PROPERTIES`	9	`CATALOG_NAME` `CHILDREN_CARDINALITY` `CUBE_NAME` `DESCRIPTION` `LEVEL_NUMBER` `MEMBER_CAPTION` `MEMBER_GUID` `MEMBER_NAME` `MEMBER_ORDINAL` `MEMBER_TYPE` `MEMBER_UNIQUE_NAME` `PARENT_COUNT` `PARENT_LEVEL` `PARENT_UNIQUE_NAME` `IS_PLACEHOLDERMEMBER` `NAME` `ID` `KEY` `CAPTION` `SCHEMA_NAME` `DIMENSION_UNIQUE_NAME` `HIERARCHY_UNIQUE_NAME` `LEVEL_UNIQUE_NAME`	Contains information about the available properties for each level of the dimension, if each level defines a class of members. The properties of all members in this class are the same. This schema table also contains all available properties for cells in a dataset. SCHEMA_NAME is obsolete.
`MDSCHEMA_MEMBERS`	12	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `DIMENSION_UNIQUE_NAME` `HIERARCHY_UNIQUE_NAME` `LEVEL_UNIQUE_NAME` `LEVEL_NUMBER` `MEMBER_NAME` `MEMBER_UNIQUE_NAME` `MEMBER_CAPTION` `MEMBER_TYPE` `Tree operator`	Contains information about the available members.
`MDSCHEMA_SETS`	4	`CATALOG_NAME` `SCHEMA_NAME` `CUBE_NAME` `SET_NAME` `SCOPE`	Contains information on any sets that are currently defined within a database, including session-scoped sets.