Db2-Get Table by Column Name

How to get Table by Column Name in DB2?

Solution

SELECT COL.TABSCHEMA AS SCHEMA_NAME,COL.TABNAME AS TABLE_NAME
FROM SYSCAT.COLUMNS COL
INNER JOIN SYSCAT.TABLES T ON T.TABSCHEMA = COL.TABSCHEMA AND T.TABNAME = COL.TABNAME
WHERE COL.COLNAME = 'CODE' AND T.TYPE = 'T'
ORDER BY SCHEMA_NAME, TABLE_NAME

More Questions