DBSCHEMA_TABLES Rowset

Identifies the measure groups and dimensions exposed as tables within Microsoft SQL Server Analysis Services.

Rowset Columns

The DBSCHEMA_TABLES rowset contains the following columns.

Column name

Type indicator

Length

Description

TABLE_CATALOG

DBTYPE_WSTR

255

The name of the catalog to which this object belongs.

TABLE_SCHEMA

DBTYPE_WSTR

255

The name of the cube to which this object belongs.

TABLE_NAME

DBTYPE_WSTR

255

The name of the object, if TABLE_TYPE is TABLE.

TABLE_TYPE

DBTYPE_WSTR

The type of the table.

TABLE indicates the object is a measure group.

SYSTEM TABLE indicates the object is a dimension.

TABLE_GUID

DBTYPE_GUID

Not supported.

DESCRIPTION

DBTYPE_WSTR

A human-readable description of the object.

TABLE_PROPID

DBTYPE_UI4

Not supported.

DATE_CREATED

DBTYPE_DBTIMESTAMP

Not supported.

DATE_MODIFIED

DBTYPE_DBTIMESTAMP

The date the object was last modified.

TABLE_OLAP_TYPE

DBTYPE_WSTR

The OLAP type of the object.

MEASURE_GROUP indicates the object is a measure group.

CUBE_DIMENSION indicated the object is a dimension.

The rowset is sorted on TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, and TABLE_NAME.

Restriction Columns

The DBSCHEMA_TABLES rowset can be restricted on the columns listed in the following table.

Column name

Type indicator

Restriction State

TABLE_CATALOG

DBTYPE_WSTR

Optional

TABLE_SCHEMA

DBTYPE_WSTR

Optional

TABLE_NAME

DBTYPE_WSTR

Optional

TABLE_TYPE

DBTYPE_WSTR

Optional

TABLE_OLAP_TYPE

DBTYPE_WSTR

Optional

See Also

Reference