Below query can be used to get list of tables having text columns in Sybase database. here syscolumns type value "35" represents text column.

use <DBNAME> /** replace your database name here **/
go
select @@servername "Server", db_name() "DB", distinct o.name as "Table_Name" from sysobjects o, syscolumns c where o.type= "U" and o.id = c.id and c.type in (35) order by 1
go

Sample output: