Fischer asked this 8 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 8 years ago

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 8 years ago

3 likes

If you have just one database,

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