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