Pasted

/** 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}'