SQLColumns

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

SQLColumns has additional Teradata-specific columns in the result set as listed in the following table.

Column Name Column Number (ODBC 3.X) Data Type Comments
LABEL 19 Varchar (256)

See (1) at end of table

Returns the column label (Teradata title) if one is provided for the column or null.
FORMAT 20 Varchar(30) Returns the Teradata format for a column or null.
CHAR_TYPE 21 Varchar(30) Returns a value describing character type.

Examples include: LATIN, KANJI1, UNICODE, and so on

TDODBC_DATA_TYPE 22 Smallint not NULL Teradata ODBC-specific SQL data type code used by the ODBC driver. If multiple database types have the same standard ODBC SQL type, then the Teradata ODBC-specific SQL data type code can be used to distinguish between the types. For an example, see Number Data Types.
(1) Varchar(256) if EON enabled, otherwise Varchar(60).