DISCOVER_STORAGE_TABLES Rowset

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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  

See Also

Analysis Services Schema Rowsets