<div>
On DB2 for i, this works for me:<br />
<br />

<pre><code id="code-20-41907519-1">select table_name,
       column_name
  from qsys2.syscolumns
 where column_name = 'SOMECOL'</code></pre>
<br />
HTH,<br />
DaveSlash
</div>


On DB2 for i, this works for me:



select table_name,
       column_name
  from qsys2.syscolumns
 where column_name = 'SOMECOL'


HTH,
DaveSlash

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have column textcode in many tables I want to find which tables have that column how can i do that.<br />
<br />
Thanks
</div>
</div>


Hi,
I have column textcode in many tables I want to find which tables have that column how can i do that.

Thanks

finding tables

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.