Volver
Ctrl+Space
◑
Copiar
Descargar
Restaurar
Ejecutar
Ctrl+Enter
-- Ejemplo 2: Ver todas las foreign keys de tutorial_db -- REFERENCED_TABLE_NAME muestra a qué tabla apunta cada FK SELECT TABLE_NAME AS tabla, COLUMN_NAME AS columna_fk, REFERENCED_TABLE_NAME AS apunta_a, REFERENCED_COLUMN_NAME AS columna_referenciada, CONSTRAINT_NAME AS nombre_constraint FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL ORDER BY TABLE_NAME
RESULTADO
Escribí un query SQL y hacé clic en
Ejecutar
o presioná
Ctrl
+
Enter