CUBES Rowset

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”

  • “VIRTUAL CUBE”
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.