Menu
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.
718
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.
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>'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
