aspose file tools*
The moose likes JDBC and the fly likes Check Table's Relationships Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Check Table Watch "Check Table New topic
Author

Check Table's Relationships

Joshua Elkino
Ranch Hand

Joined: Jul 24, 2007
Posts: 91
I think this is a simple question, but how do i check which table a foreign key refers to in mysql?

If i use describe tablename then i can see there is a key, but not sure what its refering to. I just want to verify i correctly mapped this in hibernate.

mysql> describe attendedlistent_userent;
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You can get at this sort of data by querying the database's catalog directly (refer to the MySQL documentation for the appropriate tables) or a better way is to query the DatabaseMetaData (this way your solution is not tied to one database version).


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Joshua Elkino
Ranch Hand

Joined: Jul 24, 2007
Posts: 91
For the interested...

SHOW CREATE TABLE tbl_name
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

Hi Ilya,

That's database specific though, it won't work on all systems. Paul's suggestion of using the JDBC meta data classes is preferable if you're implementing the method as part of a code base. For example, if you need to check from within the application while its running.


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Check Table's Relationships