DBSCHEMA_COLUMNS Rowset
Returns one row for every column in every DBSCHEMA schema rowset.
Rowset Columns
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. . |
|
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. |
The rowset is sorted on TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME.
Restriction Columns
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 |