[Anu_R]

Hi,

I have sybase ASE 12.0. Under the master database, I have user-defined tables (say 10 of them) created with different column names.

I need to write a query to be executed via isql that finds if any of the tables have a particular column name. For example, I need to find in which of the 10 tables, the column name is 'val'.

I know that the list of user defined tables can be queried using:
SELECT * from sysobjects where type = 'U'

Thanks!!
Anu_R

[frankp]

Try this:
select a.name
from sysobjects a, syscolumns b
where a.id = b.id
and b.name = 'column name'

Frank

[Anu_R]

Originally posted by frankp
Try this:
select a.name
from sysobjects a, syscolumns b
where a.id = b.id
and b.name = 'column name'

Frank

Thanks Frank!! this helped.

Anu_R