SQL Assistant List Columns

Tools & Utilities
Teradata Employee

SQL Assistant List Columns

Hi,

 

I stumbled upon the SQL assistant list columns function (Tools>List columns) and just wondering where does it get the information about the data types.

 

Example:

Column name     Data type    Type Name

Col1                     5                 SMALLINT

Col2                     12               VARCHAR

 

I searched DBC.COLUMNS but unable to find the above data type codes to whatever data type name it is pointed to.

 

Appreciate your response. Thanks!

 

 

RA

2 REPLIES
Teradata Employee

Re: SQL Assistant List Columns

When you click List Columns, it first calls the SQLColumns() ODBC API to list column names of the specified table.

Followed by SQLColAttributes API call which returns descriptor information for a column in a result set.

Teradata Employee

Re: SQL Assistant List Columns

Thanks Eli!