How to get table name from column in DB2?

I need the DB2 SQL query to find the table/tables from column name. I have th开发者_运维百科e column name but don't have table name which this column belongs to.

---

select TBNAME
    from sysibm.syscolumns
    where NAME = '<column name>'

---

SELECT tabname
    FROM syscat.columns
    WHERE colname = 'mycol'

---

For DB2/AS400 users:

SELECT TABLE_SCHEMA, TABLE_NAME 
    FROM QSYS2.SYSCOLUMNS 
    WHERE upper(column_name) = upper('[column_name]')

---

If you are using Visual Studio Server Explorer, I found using the following worked the best:

SELECT       TABNAME
FROM         SYSCAT.COLUMNS
WHERE        COLNAME = 'NASR_DESC'

Visual Studio still formatted it, but the formatting inserted by Visual Studio still worked.

Hope this helps someone searching for a known column name in their IBM DB2 database using Visual Studio Server Explorer.