DISCOVER_STORAGE_TABLE_COLUMNS Rowset

DISCOVER_STORAGE_TABLE_COLUMNS Rowset

 

Applies To: SQL Server 2016 Preview

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

The DISCOVER_STORAGE_TABLE_COLUMNS rowset contains the following columns.

Column nameType indicatorRestrictionDescription
DATABASE_NAMEDBTYPE_WSTRYesSpecifies 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_NAMEDBTYPE_WSTRYesSpecifies the cube or model that contains the tables.

The DISCOVER_STORAGE_TABLES rowset can be restricted by using this column.
MEASURE_GROUP_NAMEDBTYPE_WSTRYesThe name of the measure group.
DIMENSION_NAMEDBTYPE_WSTRThe name of the dimension.
ATTRIBUTE_NAMEDBTYPE_WSTRThe name of the attribute.
TABLE_IDDBTYPE_WSTRThe ID of the table.
COLUMN_IDDBTYPE_ WSTRThe ID of the column. The column ID is internal to the xVelocity in-memory analytics engine (VertiPaq) and is for information only.
COLUMN_TYPEDBTYPE_WSTRThe 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_ENCODINGDBTYPE_UI8An 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
DATATYPEDBTYPE_WSTRThe 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
ISKEYDBTYPE_BOOLTrue if the column is used as a primary or foreign key; otherwise false.
ISUNIQUEDBTYPE_BOOLTrue if the values in the column are unique; otherwise false.
ISNULLABLEDBTYPE_BOOLTrue if the column is nullable; otherwise false.
ISROWNUMBERDBTYPE_BOOLTrue if the column is a row number column. Row number columns for internal use by the xVelocity in-memory analytics engine.

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.

ArgumentValue
GUIDa07ccd44-8148-11d0-87bb-00c04fc33942
ADOMDNAMEStorageTableColumns

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  
  

Analysis Services Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft