The SETS rowset returns metadata about the sets that are available on each schema or catalog that can be accessed by the provider. Each row in the SETS schema rowset corresponds to one set that is available in the provider. The default sort order is CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, SET_NAME.
The following table describes the columns that are available in the SETS schema rowset.
| Column Name | Type Indicator | Mapped Value | Restrictions Supported? |
|---|---|---|---|
| CATALOG_NAME | DBTYPE_WSTR | Name of the catalog to which the set belongs. | Yes |
| SCHEMA_NAME | DBTYPE_WSTR | Name of the schema that contains this set. | Yes |
| CUBE_NAME | DBTYPE_WSTR | Name of the cube that contains this set. | Yes |
| SET_NAME | DBTYPE_WSTR | Name of the set. | Yes |
| SCOPE | DBTYPE_14 | Scope of the set. One of the following:
|
Yes |
| DESCRIPTION | DBTYPE_WSTR | Description of this set. | No |
Restrictions enable an OLE DB consumer to restrict the rows that are returned in a schema rowset by IDBSchemaRowset::GetRowset. A restriction is a value for a specific column. When a restriction is passed to IDBSchemaRowset::GetRowset, all rows that are returned in the schema rowset must match the restriction value on the specified column. Restriction values do not support pattern matching or wildcards. For example, the restriction value D_F matches D_F but not DEF.
Note: For definitions of the type indicators, see "Type Indicators" in Microsoft's OLE DB specification documentation.