{"id":357,"date":"2012-09-03T02:13:16","date_gmt":"2012-09-03T02:13:16","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=357"},"modified":"2012-09-03T02:13:16","modified_gmt":"2012-09-03T02:13:16","slug":"related-child-tables","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=357","title":{"rendered":"Related child tables"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nAll child tables related to a parent table name<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSELECT\r\n    p.table_name  PARENT_TABLE_NAME\r\n  , c.table_name  CHILD_TABLE\r\nFROM\r\n    all_constraints  p\r\n  , all_constraints  c\r\nWHERE\r\n    (p.constraint_type = 'P' OR p.constraint_type = 'U')\r\n    AND\r\n    (c.constraint_type = 'R')\r\n    AND\r\n    (p.constraint_name = c.r_constraint_name)\r\n    AND\r\n    (p.table_name = UPPER('&TABLE_NAME'))\r\nORDER BY 2\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSELECT<br \/>\n    p.table_name  PARENT_TABLE_NAME<br \/>\n  , c.table_name  CHILD_TABLE<br \/>\nFROM<br \/>\n    all_constraints  p<br \/>\n  , all_constraints  c<br \/>\nWHERE<br \/>\n    (p.constraint_type = 'P' OR p.constraint_type = 'U')<br \/>\n    AND<br \/>\n    (c.constraint_type = 'R')<br \/>\n    AND<br \/>\n    (p.constraint_name = c.r_constraint_name)<br \/>\n    AND<br \/>\n    (p.table_name = UPPER('&TABLE_NAME'))<br \/>\nORDER BY 2<br \/>\n\/<\/p>\n<p><\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>All child tables related to a parent table name SELECT p.table_name PARENT_TABLE_NAME , c.table_name CHILD_TABLE FROM all_constraints p , all_constraints c WHERE (p.constraint_type = &#8216;P&#8217; OR p.constraint_type = &#8216;U&#8217;) AND (c.constraint_type = &#8216;R&#8217;) AND (p.constraint_name = c.r_constraint_name) AND (p.table_name = UPPER(&#8216;&#038;TABLE_NAME&#8217;)) ORDER BY 2 \/ SELECT p.table_name PARENT_TABLE_NAME , c.table_name CHILD_TABLE FROM all_constraints p , [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":291,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-357","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5L","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=357"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/357\/revisions"}],"predecessor-version":[{"id":358,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/357\/revisions\/358"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/291"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}