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