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

Below query can be used to find identity tables in Sybase database.

1select @@servername 'Server',db_name() 'DB',convert(char(35),object_name(id)) as "Table_Name", convert(char(35),name) as "Column_Name" from syscolumns where status=128
2go

Sample output:

… Read the rest