开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜