'How to get the physical name of the fields in a table (db2 database)

Query to fetch the physical name of the field in a table ( database db2)



Solution 1:[1]

Try "Select * from syscat.columns where tabname='table name' and tabschema='table schema'"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 bbt