{"id":1811,"date":"2013-05-30T02:53:20","date_gmt":"2013-05-30T02:53:20","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=1811"},"modified":"2017-04-20T11:06:48","modified_gmt":"2017-04-20T11:06:48","slug":"how-to-get-column-names-from-db2-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/db2\/how-to-get-column-names-from-db2-table.html","title":{"rendered":"How to get column names from DB2 table"},"content":{"rendered":"<p>SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = &#8220;&lt;table name&gt;&#8221; AND tabschema = &#8220;&lt;schema name&gt;&#8221;<\/p>\n<p>See also:<\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sql%20server\/how-to-get-column-names-from-sql-server-table.html\">How to get column names from Sql Server table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/oracle\/how-to-get-column-names-from-oracle-table.html\">How to get column names from Oracle table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/mysql\/how-to-get-column-names-from-mysql-table.html\">How to get column names from Mysql table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/postgresql\/how-to-get-column-names-from-postgresql-table.html\">How to get column names from PostgreSQL table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sqlite\/how-to-get-column-names-from-sqlite-table.html\">How to get column names from SQLite table<\/a><\/p>\n<p>Some DB2 tools you can try: <a href=\"https:\/\/www.withdata.com\/db2\/\"> https:\/\/www.withdata.com\/db2\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = &#8220;&lt;table name&gt;&#8221; AND tabschema = &#8220;&lt;schema name&gt;&#8221; 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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[1318,230],"class_list":["post-1811","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-get-column-names"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=1811"}],"version-history":[{"count":4,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1811\/revisions"}],"predecessor-version":[{"id":6452,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1811\/revisions\/6452"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=1811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=1811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=1811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}