Mysql show foreign keys

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: stackoverflow.com

Mysql show foreign keys column

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: stackoverflow.com

Similar codes

0 vote228 views1 answer
Hashpass
SQL
1 vote210 views1 answer
Create temporal table in sql
SQL
7 votes252 views1 answer
Query delete duplicates
SQL
0 vote216 views1 answer
Use between operator in mysql
SQL
1 vote199 views2 answers
Install mysqldump ubuntu
SQL
7 votes209 views2 answers
Get database size mysql
SQL
19 votes209 views6 answers
What is mySQL
SQL
0 vote246 views2 answers
SQL BULK INSERT
SQL
0 vote190 views1 answer
Oracle DROP PROGRAM
SQL
0 vote230 views1 answer
Sql create and grant user access to database
SQL