1

Please advise.

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

Thanks, Srihari

Srihari
  • 2,509
  • 5
  • 30
  • 34

1 Answers1

4

Have you tried looking at the system catalog?

   SELECT CREATOR, TBNAME
   FROM   SYSIBM.SYSCOLUMNS
   WHERE  NAME = 'PHONE'
Ian Bjorhovde
  • 10,916
  • 1
  • 28
  • 25