retrieve tablename ???????

rollthecoin · #1 (**permalink**) 03-26-08, 03:35

I want a query to obtain the tablenames from the databse which contains a particular Column name... Can anyone provide a query for this

i work in db2 and unix(IBM AIX)

ARWinner · #2 (**permalink**) 03-26-08, 08:29

select distinct tabschema,tabname from syscat.columns where colname = ?

Andy

stolze · #3 (**permalink**) 03-26-08, 14:26

You can remove the DISTINCT keyword because column names are unique for each table identified by a fully qualified table name.

rollthecoin · #4 (**permalink**) 03-27-08, 05:10

Thx AR. Ur query worked.
And thx to Stolze for his reply too

Internet Services

Web Development

Digital Marketing

Consumer Tech