Re: column number in syscolumns table

For simple types, Ravi's answer is sufficient. For complex types, like rowtypes and UDT's, which only exist in 9.xx, you have to work a bit harder. Get the source for my dbschema replacement tool, myschema, and look in the source file print_types.ec for the entire thing. Myschema is contained in the package utils2_ak available for download from the IIUG Software Repository. Art S. Kagel tomL wrote: > greetings > if i have a tabname from systables (say it's tabid is 150 and it's > tabname is stakeholder) and i go look up tabid of 150 in the > syscolumns table, there is also a field in syscolumns called Colno - > how do i get the datatype that is represented by this Colno in another > system table (i am assuming there is one that will tell me this) ? > > thanks,Tom