How can I find tables, having a defined column?
db2, sql
Solution
select
*
from
syscat.columns
where
colname = 'person_name'
Problem
I am using db2 and I want to find tables, having a column named "person_name". I heard about a syscat table or something like that. How do I work with it, is it possible to do that?