Share via


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 structure described in the following table.

The default sort order is CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.

Column name

Type indicator

Description

CATALOG_NAME

DBTYPE_WSTR

Optional. The name of the catalog to which this cube belongs. NULL if the provider does not support catalogs.

SCHEMA_NAME

DBTYPE_WSTR

Optional. The name of the schema to which this cube belongs. NULL if the provider does not support schemas.

CUBE_NAME

DBTYPE_WSTR

Required. Name of the cube.

CUBE_TYPE

DBTYPE_WSTR

Required. Cube type. A provider-specific value or one of the following:

  • "CUBE"

  • "VIRTUAL CUBE"

CUBE_GUID

DBTYPE_GUID

Optional. Cube GUID. NULL if no GUID exists.

CREATED_ON

DBTYPE_DBTIMESTAMP

Optional. Date and time of cube creation. NULL if unknown.

LAST_SCHEMA_UPDATE

DBTYPE_DBTIMESTAMP

Optional. Date and time of last schema update. NULL if unknown.

SCHEMA_UPDATED_BY

DBTYPE_WSTR

Optional. User ID of the person who last updated the schema. NULL if unknown.

LAST_DATA_UPDATE

DBTYPE_DBTIMESTAMP

Optional. Date and time of last data update. NULL if unknown.

DATA_UPDATED_BY

DBTYPE_WSTR

Optional. User ID of the person who last updated the data. NULL if unknown.

DESCRIPTION

DBTYPE_WSTR

Optional. A human-readable description of the cube. If no description exists, this column is NULL.

ANNOTATIONS

DBTYPE_WSTR

Optional. A string containing annotations added by analysts through their client applications. For more information about this feature, see The ANNOTATIONS Column.