• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DatabaseMetaData.....

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic