TechNet
Export (0) Print
Expand All

DBSCHEMA_COLUMNS Rowset

 

Applies To: SQL Server 2016 Preview

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

The DBSCHEMA_COLUMNS rowset contains the following columns.

Column nameType indicatorLengthDescription
TABLE_CATALOGDBTYPE_WSTRThe name of the Database.
TABLE_SCHEMADBTYPE_WSTRNot supported.
TABLE_NAMEDBTYPE_WSTRThe name of the cube.
COLUMN_NAMEDBTYPE_WSTRThe name of the attribute hierarchy or measure.
COLUMN_GUIDDBTYPE_GUIDNot supported.
COLUMN_PROPIDDBTYPE_UI4Not supported.
ORDINAL_POSITIONDBTYPE_UI4The position of the column, beginning with 1.
COLUMN_HAS_DEFAULTDBTYPE_BOOLNot supported.
COLUMN_DEFAULTDBTYPE_WSTRNot supported.
COLUMN_FLAGSDBTYPE_UI4A DBCOLUMNFLAGS bitmask indicating column properties. See 'DBCOLUMNFLAGS Enumerated Type' in IColumnsInfo::GetColumnInfo
IS_NULLABLEDBTYPE_BOOLAlways returns false.
DATA_TYPEDBTYPE_WSTR

 DBTYPE_VARIANT
The data type of the column. Returns a string for dimension columns and a variant for measures.
TYPE_GUIDDBTYPE_GUIDNot supported.
CHARACTER_MAXIMUM_LENGTHDBTYPE_UI4The maximum possible length of a value within the column.

This is retrieved from the DataSize property in the DataItem.
CHARACTER_OCTET_LENGTHDBTYPE_UI4The 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_PRECISIONDBTYPE_UI2The maximum precision of the column for numeric data types other than DBTYPE_VARNUMERIC.
NUMERIC_SCALEDBTYPE_I2The number of digits to the right of the decimal point for DBTYPE_DECIMAL, DBTYPE_NUMERIC, DBTYPE_VARNUMERIC. Otherwise, this is NULL.
DATETIME_PRECISIONDBTYPE_UI4Not supported.
CHARACTER_SET_CATALOGDBTYPE_WSTRNot supported.
CHARACTER_SET_SCHEMADBTYPE_WSTRNot supported.
CHARACTER_SET_NAMEDBTYPE_WSTRNot supported.
COLLATION_CATALOGDBTYPE_WSTRNot supported.
COLLATION_SCHEMADBTYPE_WSTRNot supported.
COLLATION_NAMEDBTYPE_WSTRNot supported.
DOMAIN_CATALOGDBTYPE_WSTRNot supported.
DOMAIN_SCHEMADBTYPE_WSTRNot supported.
DOMAIN_NAMEDBTYPE_WSTRNot supported.
DESCRIPTIONDBTYPE_WSTRNot supported.
COLUMN_OLAP_TYPEDBTYPE_WSTRThe 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 nameType indicatorRestriction State
TABLE_CATALOGDBTYPE_WSTROptional
TABLE_SCHEMADBTYPE_WSTROptional
TABLE_NAMEDBTYPE_WSTROptional
COLUMN_NAMEDBTYPE_WSTROptional
COLUMN_OLAP_TYPEDBTYPE_WSTROptional

OLE DB Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft