SQLColumns - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-08-22
dita:mapPath
xbl1544831938754.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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).