{"id":1998,"date":"2013-08-04T23:11:00","date_gmt":"2013-08-04T21:11:00","guid":{"rendered":"http:\/\/www.tutego.de\/blog\/javainsel\/?p=1998"},"modified":"2013-08-04T23:11:00","modified_gmt":"2013-08-04T21:11:00","slug":"qa-wie-kann-man-die-foreign-keys-einer-tabelle-rausfinden","status":"publish","type":"post","link":"https:\/\/www.tutego.de\/blog\/javainsel\/2013\/08\/qa-wie-kann-man-die-foreign-keys-einer-tabelle-rausfinden\/","title":{"rendered":"Q&amp;A: Wie kann man die Foreign Keys einer Tabelle rausfinden"},"content":{"rendered":"<p>Die Metadaten k\u00f6nnen direkt erfragt werden. Quelle: <a href=\"https:\/\/svn.apache.org\/repos\/asf\/db\/ddlutils\/trunk\/src\/main\/java\/org\/apache\/ddlutils\/platform\/DatabaseMetaDataWrapper.java\">https:\/\/svn.apache.org\/repos\/asf\/db\/ddlutils\/trunk\/src\/main\/java\/org\/apache\/ddlutils\/platform\/DatabaseMetaDataWrapper.java<\/a>.<\/p>\n<p>\/**   <br \/>* Convenience method to return the foreign key meta data using the configured catalog and    <br \/>* schema pattern.    <br \/>*    <br \/>* @param tableNamePattern The pattern identifying for which tables to return info    <br \/>* @return The foreign key meta data    <br \/>* @throws SQLException If an error occurred retrieving the meta data    <br \/>* @see DatabaseMetaData#getImportedKeys(java.lang.String, java.lang.String, java.lang.String)    <br \/>*\/    <br \/>public ResultSet getForeignKeys(String tableNamePattern) throws SQLException    <br \/>{    <br \/>&#160; return getMetaData().getImportedKeys(getCatalog(), getSchemaPattern(), tableNamePattern);    <br \/>}<\/p>\n<p>Dahinter steckt also <a href=\"http:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/sql\/DatabaseMetaData.html#getImportedKeys(java.lang.String,%20java.lang.String,%20java.lang.String)\">http:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/sql\/DatabaseMetaData.html#getImportedKeys(java.lang.String,%20java.lang.String,%20java.lang.String)<\/a><\/p>\n<p>__________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Die Metadaten k\u00f6nnen direkt erfragt werden. Quelle: https:\/\/svn.apache.org\/repos\/asf\/db\/ddlutils\/trunk\/src\/main\/java\/org\/apache\/ddlutils\/platform\/DatabaseMetaDataWrapper.java. \/** * Convenience method to return the foreign key meta data using the configured catalog and * schema pattern. * * @param tableNamePattern The pattern identifying for which tables to return info * @return The foreign key meta data * @throws SQLException If an error occurred retrieving [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-1998","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/comments?post=1998"}],"version-history":[{"count":1,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1998\/revisions"}],"predecessor-version":[{"id":1999,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1998\/revisions\/1999"}],"wp:attachment":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/media?parent=1998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/categories?post=1998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/tags?post=1998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}