Schema rowsets provide metadata about a data source. The definition of data source depends on the provider being used:
Schema rowsets can be obtained through ADO by passing one of the elements of the ADO SchemaEnum enumeration to the OpenSchema method of an open Connection object.
Schema rowsets can be obtained through OLE DB by passing the GUID that represents the desired schema to the IDBSchemaRowset::GetRowset method on an open Session object.
The SAS Data Providers support the following three schema rowsets:
| Schema Rowset | Description |
|---|---|
| TABLES | Provides information about which tables (SAS data sets) are available to the data source. |
| COLUMNS | Provides information about all of the columns within those tables. |
| PROVIDER_TYPES | Indicates which data types the provider uses to expose SAS data. |
In addition, the SAS OLAP Data Provider also supports the following OLE DB for OLAP schema rowsets:
| Schema Rowset | Description |
|---|---|
| CATALOGS | Provides information about the catalogs available to the data source. |
| CUBES | Provides information about the cubes are available to the data source. |
| DIMENSIONS | Provides information about the dimensions available in a specified cube. |
| HIERARCHIES | Provides information about the hierarchies available in a specified dimension. |
| LEVELS | Provides information about the levels available in a specified dimension. |
| MEASURES | Provides information about the measures available to the data source. |
| PROPERTIES | Provides information about the properties available in each level and cell. |
| MEMBERS | Provides information about the members available to the data source. |
| FUNCTIONS | Provides information about the functions that are available to the data source. |
| SETS | Provides information about any currently defined sets. |
Refer to the following topics for more information about each schema rowset: