Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DBSCHEMA_TABLES Rowset

 

Applies To: SQL Server 2016 Preview

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

Community Additions

ADD
Show:
© 2015 Microsoft