0
(0)

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 o.name as "Table_Name" from sysobjects o, syscolumns c where o.type= "U" and o.id = c.id and c.type in (34) order by 1
go

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.