Below query can be used to get list of tables having text,image and identity columns in Sybase database.

use <DBNAME> /** replace your database name here **/
go
select @@servername "Server", db_name() "DB", o.name as "Table_Name",
user_name(o.uid) as "owner",
c.name as "Column",c.type
from sysobjects o, syscolumns c
where o.type= "U"
and o.id = c.id
and c.type in (34,35,63 ) /** 34-image, 35-text,63-identity **/
order by 1,2,3
go

Sample output: