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 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. |
| (1) Varchar(256) if EON enabled, otherwise Varchar(60). | |||