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

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.