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 **/
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

Sample output:

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.