MySQL - [solucionado] como obtener el listado de claves foraneas (foreign keys) de una tabla dada

use INFORMATION_SCHEMA;

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME

FROM KEY_COLUMN_USAGE

WHERE TABLE_SCHEMA = "base-de-datos" AND TABLE_NAME = "tabla";