File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes DatabaseMetaData..... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DatabaseMetaData....." Watch "DatabaseMetaData....." New topic
Author

DatabaseMetaData.....

Milan Djukic
Greenhorn

Joined: Feb 14, 2011
Posts: 27
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

Joined: Oct 11, 2000
Posts: 1131

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DatabaseMetaData.....