15 Jul
2009
15 Jul
'09
4:15 p.m.
Zahra Naeem a écrit :
Hi,
Can any one help me fetch foreign keys (fields) information from a table?
I mean any query that may be helpful or any structure in MYSQL that can work. I have already tried "SHOW TABLE STATUS WHERE NAME= 'abc' " query , and a lot of other things but none of them was helpful.
If anyone knows, kindly reply me ASAP:)
Best Regards, Zahra
Have a look at libraries/relation.lib.php, we have a PMA_getForeigners() function, you can pass it the $source parameter containing 'foreign'.
--
Marc Delisle
http://infomarc.info