Tuesday, September 13, 2011

How can you get name of table containing a specific column in DB2?

SELECT TABSCHEMA, TABNAME
FROM SYSCAT.COLUMNS
WHERE COLNAME='<Column Name>';

No comments :