MySQL: How to determine foreign key relationships programmatically?

SHOW TABLE STATUS WHERE Name = 'MyTableName';

SELECT CONCAT( table_name, '.', column_name, ' -> ',
  referenced_table_name, '.', referenced_column_name ) AS list_of_fks
FROM INFORMATION_SCHEMA.key_column_usage
WHERE referenced_table_schema = 'test'
  AND referenced_table_name IS NOT NULL
ORDER BY table_name, column_name;