Bug #1404 Showing REFERENCES in DESCRIBE TABLE
Submitted: 25 Sep 2003 22:44 Modified: 27 Nov 2005 10:22
Reporter: Kris Amy Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:4.0.11 OS:Linux (Debian GNU/Linux)
Assigned to: CPU Architecture:Any

[25 Sep 2003 22:44] Kris Amy 
Description:
Is it possible to display the REFERENCES that a column has in a DESCRIBE.

How to repeat:
DESCRIBE TABLENAME
[26 Nov 2005 12:17] Valeriy Kravchuk 
Thank you for a feature request. I agree, that there should be some way to figure out that columns are a part of a foreign key, and what table and columns they are referencing to. But I am not sure it is reasonable to include such an information in DESCRIBE results, because it was created mostly to imitate Oracle's DESCRIBE command behaviour. I think, the appropriate information will be included into the INFORMATION_SCHEMA in future 5.x.x versions, to conform to the SQL 2003 standard.
[27 Nov 2005 10:22] Valeriy Kravchuk 
Sorry, looks like the information about references is already included into the INFORMATION_SCHEMA of 5.0.x:

http://dev.mysql.com/doc/refman/5.0/en/key-column-usage-table.html

So, there is no need to add it anywhere.