The CUBES rowset contains information about the available cubes in a schema (or the catalog, if the provider does not support schemas). It has the following columns:
Column name | Type indicator | Description |
CATALOG_NAME | DBTYPE_WSTR | The name of the catalog to which this cube belongs. NULL if the provider does not support catalogs. |
SCHEMA_NAME | DBTYPE_WSTR | The name of the schema to which this cube belongs. NULL if the provider does not support schemas. |
CUBE_NAME | DBTYPE_WSTR | Name of the cube. |
CUBE_TYPE | DBTYPE_WSTR | Cube type. One of the following, or a provider-specific value:
|
CUBE_GUID | DBTYPE_GUID | Cube GUID. NULL if no GUID exists. |
CREATED_ON | DBTYPE_DBTIMESTAMP | Date and time of cube creation. NULL if unknown. |
LAST_SCHEMA_UPDATE | DBTYPE_DBTIMESTAMP | Date and time of last schema update. NULL if unknown. |
SCHEMA_UPDATED_BY | DBTYPE_WSTR | User ID of the person doing the last schema update. NULL if unknown. |
LAST_DATA_UPDATE | DBTYPE_DBTIMESTAMP | Date and time of last data update. NULL if unknown. |
DATA_UPDATED_BY | DBTYPE_WSTR | User ID of the person doing the last data update. NULL if unknown. |
DESCRIPTION | DBTYPE_WSTR | A human-readable description of the cube. If no description exists, then this is NULL. |
The default sort order is CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.