I'm still fairly new in the Sybase support running ASA8. Anyway vendor delivered app & DB. Trying to extract data.

I want to pull in the column type (i.e. varchar, integer...) from the DB. I've got this down as the query:

SELECT SYSTABLE.TABLE_ID, SYS.SYSTABLE.TABLE_NAME, SYS.SYSCOLUMN.COLUMN_NAME,
SYS.SYSCOLUMN.PKEY, SYS.SYSCOLUMN.NULLS, SYS.SYSCOLUMN.WIDTH
FROM SYS.SYSTABLE, SYS.SYSCOLUMN
WHERE SYSTABLE.TABLE_ID IN (SELECT TABLE_ID FROM SYS.SYSCOLUMN)
AND SYSTABLE.TABLE_ID = SYSCOLUMN.TABLE_ID
AND UPPER(LEFT(SYS.SYSTABLE.TABLE_NAME,3)) <> 'SYS'

1. Is it the systypes table.
2. Most of the user_type column is null for the syscolumns table.

I think this might be close to what you're looking for:
select a.id, a.name, b.colid, b.name, c.name, b.length
from sysobjects a, syscolumns b, systypes c
where a.name in (select name from sysobjects where type = 'U')
and a.id = b.id
and b.type = c.type
and c.name not in ('sysname', 'nid', 'uid', 'nvarchar', 'tid', 'nchar')

No joy. That query is broken.

But you gave me the answer I needed anyway.

I was trying to build my own version of SYSCOLUMNS. If you note in my query I was going against SYSCOLUMN (no "S"). That was my bad. What I was really looking for was SYSCOLUMNS. Comes from being in Oracle too long, first.

Thanks

That query works fine on 11.9.2. I tried it on a couple of servers.

They must have made changes to the database structure for ASA 8 vs 11.9.2.

Thanks again.