I'm trying to build a data dictionary for my Sybase tables. I found the following code which works great. But I also need the datatype. Can anyone point me to the correct location?
select O.name as "Table"
, C.name as "Column", C.length as "Length"
from sysobjects O
, syscolumns C
where O.id = C.id
and O.type = "U" -- user tables only
order by O.name, C.colid