{"id":5428,"date":"2016-10-21T08:42:13","date_gmt":"2016-10-21T08:42:13","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=5428"},"modified":"2017-04-20T11:10:41","modified_gmt":"2017-04-20T11:10:41","slug":"how-to-get-column-names-from-sqlite-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/sqlite\/how-to-get-column-names-from-sqlite-table.html","title":{"rendered":"How to get column names from SQLite table"},"content":{"rendered":"<p><code>PRAGMA table_info(table_name);<\/code><\/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\/db2\/how-to-get-column-names-from-db2-table.html\">How to get column names from DB2 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>Some SQLite tools you can try: <a href=\"https:\/\/www.withdata.com\/sqlite\/\"> https:\/\/www.withdata.com\/sqlite\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PRAGMA table_info(table_name); see also: How to get column names from Sql Server table How to get column names from DB2 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 Some SQLite tools you can try: https:\/\/www.withdata.com\/sqlite\/<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[429],"tags":[230,1369],"class_list":["post-5428","post","type-post","status-publish","format-standard","hentry","category-sqlite","tag-get-column-names","tag-sqlite"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5428","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=5428"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5428\/revisions"}],"predecessor-version":[{"id":6464,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5428\/revisions\/6464"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=5428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=5428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=5428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}