{"id":716,"date":"2014-07-21T19:26:18","date_gmt":"2014-07-21T19:26:18","guid":{"rendered":"http:\/\/putridparrot.com\/blog\/?p=716"},"modified":"2014-07-21T19:26:18","modified_gmt":"2014-07-21T19:26:18","slug":"describing-my-tables-views-stored-procs-etc","status":"publish","type":"post","link":"https:\/\/putridparrot.com\/blog\/describing-my-tables-views-stored-procs-etc\/","title":{"rendered":"Describing my tables, views, stored procs etc."},"content":{"rendered":"<p>Having become a little too reliant (at times) on great GUI tools for interacting with my databases, I had to remind myself it&#8217;s pretty easy to use code to do this, sure good old Aqua Studio does it with CTRL+D on a data object in the editor, or both Oracle SQL Developer and the MS SQL Server Management Studio allow us to easily drill down the item in the data object tree, but still. Here it is in code&#8230;<\/p>\n<p><strong>Tables and views<\/strong><\/p>\n<p>For Oracle<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\ndesc TableName\r\n<\/pre>\n<p>For SQL Server<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nexec sp_columns TableName\r\n<\/pre>\n<p><strong>Stored Procs<\/strong><\/p>\n<p>For Oracle<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\ndesc StoredProceName\r\n<\/pre>\n<p>For SQL Server<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nexec sp_help StoredProceName\r\n<\/pre>\n<p>In fact sp_help can be used for Stored Procs and Tables\/Views.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having become a little too reliant (at times) on great GUI tools for interacting with my databases, I had to remind myself it&#8217;s pretty easy to use code to do this, sure good old Aqua Studio does it with CTRL+D on a data object in the editor, or both Oracle SQL Developer and the MS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[22,52,10,23],"tags":[],"class_list":["post-716","post","type-post","status-publish","format-standard","hentry","category-database","category-oracle","category-sql","category-sql-server"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=716"}],"version-history":[{"count":3,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":2183,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/716\/revisions\/2183"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}