Obtener la referencia o el foreign de una tabla

[Genetix]

prueba con esto

Código:

SELECT  CONSTRAINT_NAME as constraint_name,
				    REFERENCED_TABLE_SCHEMA as fkschema,
				    TABLE_NAME as table_name,
				    COLUMN_NAME as column_name,
				    REFERENCED_TABLE_NAME as references_table,
				    REFERENCED_COLUMN_NAME as references_field,
				    concat("FOREIGN KEY") as constraint_type
				FROM

				    `INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE`
				WHERE
				 	REFERENCED_TABLE_NAME IS NOT NULL
					AND TABLE_NAME = 'tu_tabla'
					AND TABLE_SCHEMA = 'tu_db';