Question : mysql show foreign keys
Answered by : vastemonde
SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_SCHEMA = '<database>' AND REFERENCED_TABLE_NAME = '<table>';
Source : https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column | Last Update : Mon, 30 Aug 21
Question : mysql show foreign keys column
Answered by : vastemonde
SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_SCHEMA = '<database>' AND REFERENCED_TABLE_NAME = '<table>' AND REFERENCED_COLUMN_NAME = '<column>';
Source : https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column | Last Update : Mon, 30 Aug 21