This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DatabaseMetaData.....

 
Milan Djukic
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can i get all foreign key columns with theirs mother tables?

For example i have AA foreign column. How to know what table is mother table of this column?

I use DatabaseMetaData interface and i know how to get foreign columns but dont know how to get mother tables
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Milan,
Am I missing something, for it seems to me that the answer to your question is RTFM.
See the javadoc for method getImportedKeys in interface DatabaseMetaData.

Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table). They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:

1.PKTABLE_CAT String => primary key table catalog being imported (may be null)
2.PKTABLE_SCHEM String => primary key table schema being imported (may be null)
3.PKTABLE_NAME String => primary key table name being imported
4.PKCOLUMN_NAME String => primary key column name being imported
5.FKTABLE_CAT String => foreign key table catalog (may be null)
6.FKTABLE_SCHEM String => foreign key table schema (may be null)
7.FKTABLE_NAME String => foreign key table name
8.FKCOLUMN_NAME String => foreign key column name
9.KEY_SEQ short => sequence number within a foreign key( a value of 1 represents the first column of the foreign key, a value of 2 would represent the second column within the foreign key).
10.UPDATE_RULE short => What happens to a foreign key when the primary key is updated:
◦importedNoAction - do not allow update of primary key if it has been imported
◦importedKeyCascade - change imported key to agree with primary key update
◦importedKeySetNull - change imported key to NULL if its primary key has been updated
◦importedKeySetDefault - change imported key to default values if its primary key has been updated
◦importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
11.DELETE_RULE short => What happens to the foreign key when primary is deleted.
◦importedKeyNoAction - do not allow delete of primary key if it has been imported
◦importedKeyCascade - delete rows that import a deleted key
◦importedKeySetNull - change imported key to NULL if its primary key has been deleted
◦importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
◦importedKeySetDefault - change imported key to default if its primary key has been deleted
12.FK_NAME String => foreign key name (may be null)
13.PK_NAME String => primary key name (may be null)
14.DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
◦importedKeyInitiallyDeferred - see SQL92 for definition
◦importedKeyInitiallyImmediate - see SQL92 for definition
◦importedKeyNotDeferrable - see SQL92 for definition

Good Luck,
Avi.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic