Bug #3283 | Extracting Foreign Key Information | ||
---|---|---|---|
Submitted: | 24 Mar 2004 8:49 | Modified: | 2 Dec 2005 16:45 |
Reporter: | Tim Gustafson | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | 4.0.18 | OS: | FreeBSD (FreeBSD 4.9-STABLE) |
Assigned to: | CPU Architecture: | Any |
[24 Mar 2004 8:49]
Tim Gustafson
[2 Dec 2005 16:45]
Valeriy Kravchuk
Thank you for a feature request. One way to get this information is already implemented in MySQL 5, in the INFORMATION_SCHEMA. Read http://dev.mysql.com/doc/refman/5.0/en/table-constraints-table.html and http://dev.mysql.com/doc/refman/5.0/en/key-column-usage-table.html for the detais.