Export (0) Print
Expand All

DBSCHEMA_TABLES Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft