Find Out matching Columns from tables
SELECT TBNAME FROM SYSIBM.SYSCOLUMNS WHERE NAME = 'val'
Tip:
Adding the schema name/creator name in the select list will be helpful
If you are using DB2 on Unix/Win as a standard use syscat.columns ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment