See Foreign Key

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

Source: tableplus.com

Similar codes

3 votes199 views1 answer
Postgresql db owner change
SQL
0 vote220 views1 answer
Systems sql
SQL
0 vote216 views1 answer
Use between operator in mysql
SQL
20 votes217 views6 answers
Change password in mysql
SQL
0 vote195 views1 answer
Sql delete where x or y or z
SQL
2 votes201 views1 answer
Columns Present in a table
SQL
0 vote206 views1 answer
Sql list dates between two dates
SQL
0 vote195 views1 answer
Check if record exists mysql
SQL
0 vote219 views1 answer
Sql doesn't contain
SQL
1 vote197 views1 answer
Mysql check if string contains comma separated
SQL