16.20 - SQLColumns - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
August 2020
User Guide

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 ODBC Driver for Teradata. 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).