15.10 - SQLColumns - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

SQLColumns has additional Teradata-specific columns in the result set as listed in Table 33.

 

Table 33: Additional SQLColumns Teradata ODBC-specific Columns 

Column Name

Column Number (ODBC 3.X)

Data Type

Comments

LABEL

19

Varchar (256)1

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” on page 138.


1
Varchar(256) if EON enabled, otherwise Varchar(60).