Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

DISCOVER_STORAGE_TABLE_COLUMNS Rowset

SQL Server 2012

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 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.

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

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.