Withdata Software

How to get column names from DB2 table

SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = “<table name>” AND tabschema = “<schema name>”

See also:

How to get column names from Sql Server table

How to get column names from Oracle table

How to get column names from Mysql table

How to get column names from PostgreSQL table

How to get column names from SQLite table

Some DB2 tools you can try: https://www.withdata.com/db2/

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.