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