Check Table's Relationships

[Joshua Elkino]

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;

+--------------------+------------+------+-----+---------+-------+
| Field              | Type       | Null | Key | Default | Extra |
+--------------------+------------+------+-----+---------+-------+
| AttendedListEnt_id | bigint(20) | NO   | PRI |         |       |
| userList_id        | bigint(20) | NO   | PRI |         |       |
+--------------------+------------+------+-----+---------+-------+

[Paul Sturrock]

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).

[Joshua Elkino]

For the interested...

SHOW CREATE TABLE tbl_name

[Scott Selikoff]

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.