DBSCHEMA_TABLES Rowset
Identifies the measure groups and dimensions exposed as tables within Microsoft SQL Server 2005 Analysis Services (SSAS).
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 |