MYSQL: Get Table Foreign Keys

/** RapidMod.io **/
/** Find foreign keys by table **/

SELECT
    TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
    REFERENCED_TABLE_SCHEMA = '{$dbname}'
AND
    TABLE_NAME = '{$table}'