Export (0) Print
Expand All

DBSCHEMA_COLUMNS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Provides column information for all columns meeting the provided restriction criteria.

The DBSCHEMA_COLUMNS rowset contains the following columns.

Column name

Type indicator

Length

Description

TABLE_CATALOG

DBTYPE_WSTR

The name of the Database.

TABLE_SCHEMA

DBTYPE_WSTR

Not supported.

TABLE_NAME

DBTYPE_WSTR

The name of the cube.

COLUMN_NAME

DBTYPE_WSTR

The name of the attribute hierarchy or measure.

COLUMN_GUID

DBTYPE_GUID

Not supported.

COLUMN_PROPID

DBTYPE_UI4

Not supported.

ORDINAL_POSITION

DBTYPE_UI4

The position of the column, beginning with 1.

COLUMN_HAS_DEFAULT

DBTYPE_BOOL

Not supported.

COLUMN_DEFAULT

DBTYPE_WSTR

Not supported.

COLUMN_FLAGS

DBTYPE_UI4

A DBCOLUMNFLAGS bitmask indicating column properties. See 'DBCOLUMNFLAGS Enumerated Type' in IColumnsInfo::GetColumnInfo

IS_NULLABLE

DBTYPE_BOOL

Always returns false.

DATA_TYPE

DBTYPE_WSTR

DBTYPE_VARIANT

The data type of the column. Returns a string for dimension columns and a variant for measures.

TYPE_GUID

DBTYPE_GUID

Not supported.

CHARACTER_MAXIMUM_LENGTH

DBTYPE_UI4

The maximum possible length of a value within the column.

This is retrieved from the DataSize property in the DataItem.

CHARACTER_OCTET_LENGTH

DBTYPE_UI4

The maximum possible length of a value within the column, in bytes, for character or binary columns.

A value of zero (0) indicates the column has no maximum length.

NULL will be returned for columns that do not return binary or character data types.

NUMERIC_PRECISION

DBTYPE_UI2

The maximum precision of the column for numeric data types other than DBTYPE_VARNUMERIC.

NUMERIC_SCALE

DBTYPE_I2

The number of digits to the right of the decimal point for DBTYPE_DECIMAL, DBTYPE_NUMERIC, DBTYPE_VARNUMERIC. Otherwise, this is NULL.

DATETIME_PRECISION

DBTYPE_UI4

Not supported.

CHARACTER_SET_CATALOG

DBTYPE_WSTR

Not supported.

CHARACTER_SET_SCHEMA

DBTYPE_WSTR

Not supported.

CHARACTER_SET_NAME

DBTYPE_WSTR

Not supported.

COLLATION_CATALOG

DBTYPE_WSTR

Not supported.

COLLATION_SCHEMA

DBTYPE_WSTR

Not supported.

COLLATION_NAME

DBTYPE_WSTR

Not supported.

DOMAIN_CATALOG

DBTYPE_WSTR

Not supported.

DOMAIN_SCHEMA

DBTYPE_WSTR

Not supported.

DOMAIN_NAME

DBTYPE_WSTR

Not supported.

DESCRIPTION

DBTYPE_WSTR

Not supported.

COLUMN_OLAP_TYPE

DBTYPE_WSTR

The OLAP type of the object.

MEASURE indicates the object is a measure.

ATTRIBUTE indicates the object is a dimension attribute.

SCHEMA indicates the object is a column in a schema.

The rowset is sorted on TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME.

The DBSCHEMA_COLUMNS rowset can be restricted on the columns listed in the following table.

Column name

Type indicator

Restriction State

TABLE_CATALOG

DBTYPE_WSTR

Optional

TABLE_SCHEMA

DBTYPE_WSTR

Optional

TABLE_NAME

DBTYPE_WSTR

Optional

COLUMN_NAME

DBTYPE_WSTR

Optional

COLUMN_OLAP_TYPE

DBTYPE_WSTR

Optional

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft