Answers

Question and Answer:

  Home  IBM DB2

⟩ I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables.

select * from sysibm.syscolumns where name = <name you 3

columns here>

The above query to metadata will show you the list of table

names where these 3 columsn present

 190 views

More Questions for you: