How to know which all tables have the column ex PHONE?

Question

Please advise.

In Db2 database how can I know the list of tables that contain the column ex PHONE?

Thanks, Srihari

Answer 1

Have you tried looking at the system catalog?

   SELECT CREATOR, TBNAME
   FROM   SYSIBM.SYSCOLUMNS
   WHERE  NAME = 'PHONE'