共用方式為


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

請參閱

參考

OLE DB Schema Rowsets

說明及資訊

取得 SQL Server 2005 協助