How To Get Proper Column Types In Sybase

I have to know the data type of some columns in my table in Sybase ASE. Here is my query select name from systypes where type in (39, 47, 39, 39, 106 ) this returns char va

Solution 1:

You need to join systypes to syscolumns on both the type and usertype columns.