::. Moleculax - Programming free online - Data Base NoSQL - OOP - Deep Web- Dark Web - BigData - PostgreSQL - MySQL - Programming - OOP freebitcoin.:: Moleculax - TECHNOLOGY AND KNOWLEDGE Information technology, Structured programming

MySql Consultar las relaciones entre tablas

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA="nombre_bd" AND CONSTRAINT_TYPE="FOREIGN KEY"

SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA="nombre_bd"

Obtener el campo con la FK dentro de una tabla y a que tabla y campo apunta:

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE CONSTRAINT_SCHEMA="nombre_bd" AND TABLE_NAME="nombre_tabla" AND REFERENCED_TABLE_SCHEMA="nombre_bd"

.