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",… Read the rest

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

use <DBNAME /** replace your database name here **/
go
select @@servername "Server", db_name() "DB", distinct … Read the rest