Columns Schema Rowset - OLE DB Provider for Teradata

Columns Schema Rowset

Table 28: Columns Schema Rowset

Default Sort Order	Supported Restrictions	Supported Columns
TABLE_SCHEMA TABLE_NAME	TABLE_SCHEMA TABLE_NAME COLUMN_NAME	TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_HASDEFAULT COLUMN_FLAGS IS_NULLABLE DATA_TYPE NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION DESCRIPTION LABEL FORMAT CHAR_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH

Specify Restrictions

The following restriction applies:

If the TABLE_SCHEMA is unrestricted, then OLE DB Provider for Teradata uses the default database as described in the previous “Default Database” on page 84.

Privileges

If the consumer specifies a table that the user does not have privilege to access, then IDBSchemaRowset::GetRowset returns the S_OK error code. However, no rows are returned.

COLUMN_HASDEFAULT Limitation

COLUMN_HASDEFAULT always returns FALSE for views whether or not the DEFAULT clause has been specified for a column. This is a known limitation.

Sort Limitation

The data returned is not correctly sorted. The sort on TABLE_NAME is case insensitive.

Custom Columns

The LABEL, FORMAT, and CHAR_TYPE are custom columns. The data returned for each column are as follows:

Table 29: Custom Columns

Column	Data Returned
CHAR_TYPE	The character set specified for the column.
FORMAT	The text specified in the FORMAT clause
LABEL	The text specified in the TITLE clause