DISCOVER_STORAGE_TABLES Rowset
Allows the client to determine the tables that are included in an Analysis Services database running in Tabular or SharePoint mode.
Rowset Columns
The DISCOVER_STORAGE_TABLES rowset contains the following columns.
Column name |
Type indicator |
Length |
Description |
|---|---|---|---|
DATABASE_NAME |
DBTYPE_WSTR |
Specifies the database name that contains the tables. The DISCOVER_STORAGE_TABLES rowset can be restricted by using this column. If this column is not used to restrict the rowset, the current database is used. |
|
CUBE_NAME |
DBTYPE_WSTR |
Specifies the cube or model that contains the tables. The DISCOVER_STORAGE_TABLES rowset can be restricted by using this column. |
|
MEASURE_GROUP_NAME |
DBTYPE_WSTR |
The name of the measure group. |
|
PARTITION_NAME |
DBTYPE_WSTR |
The name of the partition. |
|
DIMENSION_NAME |
DBTYPE_WSTR |
The name of the dimension. |
|
TABLE_ID |
DBTYPE_WSTR |
The ID of the table that is used to store the table attributes. |
|
TABLE_PARTITIONS_COUNT |
DBTYPE_ WSTR |
The table partition count. |
|
HINT_TABLE_TYPE |
DBTYPE_ WSTR |
The hint of the table type. |
|
ROWS_COUNT |
DBTYPE_UI4 |
The number of rows in the partition. |
|
RIVIOLATION_COUNT |
DBTYPE_UI4 |
The number of rows with referential integrity violations. |
Restriction Columns
The DISCOVER_STORAGE_TABLES rowset can be restricted on the columns listed in the following table.
Column name |
Type indicator |
Restriction State |
|---|---|---|
DATABASE_NAME |
DBTYPE_WSTR |
Optional. |
CUBE_NAME |
DBTYPE_WSTR |
Optional. |
MEASURE_GROUP_NAME |
DBTYPE_WSTR |
Optional |
PARTITION_NAME |
DBTYPE_WSTR |
Optional |
Example
The following code sample returns a list of the storage tables and the number of rows in each, from the default database on the current connection.
SELECT TABLE_ID, ROWS_COUNT
FROM $system.DISCOVER_STORAGE_TABLES
ORDER BY TABLE_ID DESC