Sybase ADDICT

Might be a good idea to share some usefull code snippet. Let’s start with a simple query to find out text/image columns in a database. This one will build a list of columns using text/image columns for each tables:

select user_name(o.uid) as "owner",
o.name as "table",
c.name as "column"
from   sysobjects o, syscolumns c
where  o.type = "U"
and    o.id = c.id
and    c.type in (34,35)
order  by 1,2,3
go

Enjoy