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.
精彩评论