{"id":610,"date":"2013-01-15T22:27:58","date_gmt":"2013-01-15T22:27:58","guid":{"rendered":"http:\/\/shivdev.com\/blog\/?p=610"},"modified":"2013-01-15T22:31:32","modified_gmt":"2013-01-15T22:31:32","slug":"list-columns-in-a-table","status":"publish","type":"post","link":"http:\/\/shivdev.com\/blog\/2013\/01\/15\/list-columns-in-a-table\/","title":{"rendered":"List columns in a table"},"content":{"rendered":"<p>For, <strong>Oracle<\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n-- This is Case Sensitive\r\nSELECT column_name, data_type\r\nFROM user_tab_cols\r\nWHERE UPPER(table_name) = UPPER('MY_TABLE') \r\n<\/pre>\n<p>For, <strong>MySQL<\/strong>, you can either do a <strong>desc my_table<\/strong> or<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSHOW COLUMNS FROM my_table \r\n<\/pre>\n<p>For <strong>SQL Server<\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT * \r\nFROM information_schema.columns \r\nWHERE table_name = 'my_table'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>For, Oracle For, MySQL, you can either do a desc my_table or For SQL Server<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/610"}],"collection":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":5,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":615,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions\/615"}],"wp:attachment":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}