List:General Discussion« Previous MessageNext Message »
From:Kris Date:July 2 2010 11:56pm
Subject:Retrieving table and field a foreign key references
View as plain text  
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 example, the following do not provide this information:

- show create table address;
- describe address;
- select * from TABLE_CONSTRAINTS;
- select * from key_column_usage;

CREATE TABLE state
(
id VARCHAR(2) PRIMARY KEY,
name TEXT
);

CREATE TABLE address
(id INT PRIMARY KEY,
address text,
zipcode INT,
sid VARCHAR(2),
FOREIGN KEY(sid) REFERENCES state(id)
);

Thread
Retrieving table and field a foreign key referencesKris3 Jul
  • Re: Retrieving table and field a foreign key referencesPeter Brawley3 Jul
  • Re: Retrieving table and field a foreign key referencesBaron Schwartz3 Jul