Fischer asked this 3 years ago

MySQL: List all foreign keys in a table

How do i list all the foreign keys in a MySQL table?

 


Best Answer by mohlal
6 likes

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'database_name' AND REFERENCED_TABLE_NAME = 'table_name';

mkbaines 2 years ago
3 likes

If you have just one database,

select *
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS
where CONSTRAINT_TYPE = 'FOREIGN KEY'