SQLColumns has additional Teradata-specific columns in the result set as listed in Table 33.
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. |