DISCOVER_STORAGE_TABLE_COLUMNS Rowset

Provides information at the column level about storage tables used by an Analysis Services database running in SharePoint or Tabular mode.

Applies to: tabular models

Rowset Columns

The DISCOVER_STORAGE_TABLE_COLUMNS rowset contains the following columns.

Column name Type indicator Restriction Description
DATABASE_NAME DBTYPE_WSTR Yes Specifies the database name that contains the tables. If omitted, the current database is used.

The DISCOVER_STORAGE_TABLE_COLUMNS rowset can be restricted by using this column.
CUBE_NAME DBTYPE_WSTR Yes 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 Yes The name of the measure group.
DIMENSION_NAME DBTYPE_WSTR The name of the dimension.
ATTRIBUTE_NAME DBTYPE_WSTR The name of the attribute.
TABLE_ID DBTYPE_WSTR The ID of the table.
COLUMN_ID DBTYPE_ WSTR The ID of the column. The column ID is internal to the xVelocity in-memory analytics engine (VertiPaq) and is for information only.
COLUMN_TYPE DBTYPE_WSTR The type of column. The column type is internal to the xVelocity in-memory analytics engine (VertiPaq) and is for information only.

BASIC_DATA

HIERARCHY_DATAID_TO_POSITION

HIERARCHY_POSITION_TO_DATAID

RELATIONSHIP
COLUMN_ENCODING DBTYPE_UI8 An integer that represents the type of encoding used for column data.

0, used with COLUMN_TYPE: HIERARCHY_DATAID_TO_POSITION, HIERARCHY_POSITION_TO_DATAID, RELATIONSHIP

1, used with COLUMN_TYPE: BASIC_DATA

2, used with COLUMN_TYPE: BASIC_DATA
DATATYPE DBTYPE_WSTR The data type of the column. Has the following possible values:

DBTYPE_BOOL

DBTYPE_CY

DBTYPE_DATE

DBTYPE_I4

DBTYPE_I8

DBTYPE_R8

DBTYPE_WSTR

N/A
ISKEY DBTYPE_BOOL True if the column is used as a primary or foreign key; otherwise false.
ISUNIQUE DBTYPE_BOOL True if the values in the column are unique; otherwise false.
ISNULLABLE DBTYPE_BOOL True if the column is nullable; otherwise false.
ISROWNUMBER DBTYPE_BOOL True if the column is a row number column. Row number columns for internal use by the xVelocity in-memory analytics engine.

Using ADOMD.NET to return the rowset

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument Value
GUID a07ccd44-8148-11d0-87bb-00c04fc33942
ADOMDNAME StorageTableColumns

Example

The following code sample uses a DMV query to return the result set.

SELECT *  
FROM $System.DISCOVER_STORAGE_TABLE_COLUMNS  
ORDER BY TABLE_ID DESC  

See Also

Analysis Services Schema Rowsets