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 the column name but don't have table name which this column belongs to.

What is Syscat in DB2?

TABLES. Contains one row for each table, view, or alias that is created. All of the catalog tables and views have entries in the SYSCAT.

How do you find the details of a table?

To show table properties in the Properties window. In Object Explorer, select the table for which you want to show properties. Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.

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

Related questions

Storing a really large number in SQL Server

List of tables used in an SQL Query

Cyrillic symbols in SQL code are not correctly after insert

PostgreSQL query returning multiple rows based on id

Sqlite select max query and sorting

How to check if a variable has a value in a SQL Server 2008 stored procedure

MySQL Sum positive and negative - calculate the exact total from money transactions

Append to spool file Oracle

Get list of columns in a temp table in SQL Server

transaction isolation problem or wrong approach?

What to do when I want to use database constraints but only mark as deleted instead of deleting?

IF statement in ORDER BY Clause of a SELECT Statement in a SQL Server Stored Procedure

SQL CHECK constraint to prevent date overlap

Storing Result set into an array

cannot perform DML operation inside a query

Is using COUNT(*) or SELECT * a good idea?

SQL table design: Should I store addresses with orders or in separate table?

How do I select dates between two given dates in an Oracle query?

How to determine which version of SQL Server is running using T-SQL

Retrieving billions of rows from remote server?

How to get table name from column in DB2?

Tags:

sql

columnname

tablename

db2

AAA_king

People also ask

1 Answers

boes

Recent Activity

Donate For Us