How do Ilist tables based on column name in sybase?

Question

How do I list all the tables in a database that contain a column with a given name?

Answer 1

Try this:

select distinct object_name(id)
from syscolumns
where name = 'my_column_name'
order by object_name(id)

or this way:

select distinct so.name
from syscolumns sc
  , sysobjects so
where sc.id = so.id
and   sc.name = 'my_column_name'
order by so.name

is that what you've been looking for?

Answer 2

You can also use sp_columns stored procedure.

sp_columns @column_name = '%column_name%'

More info here: SyBooks Online (Getting Help On Database Objects)