Getting column type from sybase SQL

Question

Where I can get column type name from sybase iq SQL

select * from syscolumn
select distinct column_type from syscolumn --- value is only R

Where can I get like int, varchar, etc..?

select * from systypes

How to relate with syscolumns?

http://stackoverflow.com/questions/27567890/how-to-get-proper-column-types-in-sybase — Mike Gardner, Feb 18 '15 at 14:39

score 3 · Accepted Answer · answered Feb 18 '15 at 14:26

3

Since MS SQL Server share a lot of design features with Sybase and this works with MS SQL Server it should work with Sybase ASE too (although I haven't tried it due to lack of Sybase server):

select c.name as column_name, t.name as type_name 
from syscolumns c
join systypes t on c.type = t.type

Looking at the Sybase Adaptive Server Enterprise 15.7 documentation for syscolumns and systypes this seems correct.

answered Feb 18 '15 at 14:26

jpw

44,361
6
66
86

Unfortunately i have not syscolumns, i have in the database syscolumn (without 's'). I want to select sc.column_name,st.name from systypes st, syscolumn sc where _??__. – user2301515 Feb 19 '15 at 08:29
@user2301515 Are you saying the query doesn't work? Which version of the Sybaser software are you using? – jpw Feb 19 '15 at 08:41
I have version Sybase IQ 15.2. – user2301515 Feb 19 '15 at 12:00
This doesn't work as systypes is not unique on the type column. – polyglot Apr 08 '21 at 06:25

Getting column type from sybase SQL

1 Answers1