How to get table name from column in DB2?

sql db2 tablename columnname
AAA_king picture AAA_king · Sep 1, 2011 · Viewed 51.8k times · Source

I need the db2 sql query to find the table/tables from column name. I have the column name but don't have table name which this column belongs to.

Answer

boes picture boes · Sep 1, 2011 
select TBNAME
    from sysibm.syscolumns
    where NAME = '<column name>'

Related questions

DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the …

Read More
show all tables in DB2 using the LIST command

This is embarrassing, but I can't seem to find a way to list the names of the tables in our DB2 database. Here is what I tried: root@VO11555:~# su - db2inst1 root@VO11555:~# . ~db2inst1/sqllib/db2profile …

Read More
DB2 Date format

I just want to format current date into yyyymmdd in DB2. I see the date formats available, but how can I use them? http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.…

Read More