For example, the following do not provide this information:
- show create table address;
- describe address;
- select * from TABLE_CONSTRAINTS;
- select * from key_column_usage;
For tables not using transactional engines like InnoDB, MySQL discards
foreign key specs, otherwise see Find
Kris,
You can use SHOW CREATE TABLE.
On Fri, Jul 2, 2010 at 7:56 PM, Kris mk...@gmx.net wrote:
Hello,
I am having trouble finding a way to retrieve the table and field a
foreign key references by querying MySQL. If you look at the following
example tables, there is no way after the tables
Hello,
I am having trouble finding a way to retrieve the table and field a
foreign key references by querying MySQL. If you look at the following
example tables, there is no way after the tables are created to learn
that:
- address.sid actually references state.id
Is this possible ?
For
