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'.