mysql find foreign key references

Solutions on MaxInterview for mysql find foreign key references by the best coders in the world

Search
showing results for - "mysql find foreign key references"
Luca
06 Jul 2019
1SELECT
2  TABLE_NAME,
3  COLUMN_NAME,
4  CONSTRAINT_NAME,   -- <<-- the one you want! 
5  REFERENCED_TABLE_NAME,
6  REFERENCED_COLUMN_NAME
7FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
8WHERE
9  REFERENCED_TABLE_NAME = 'My_Table';
similar questions
mysql show foreign keysfk in insert mysqlmysql add foreign keymysql foreign key constraintscreate table mysql with foreign keyforeign key type uniqu mysqlhow to connect database foreign key in mysqlupdate foreign key value in mysqlalter table add foreign key mysqlmysql set foreign key checks 3d0get foreign table names mysqlforeign key sqlalchemymysql modify foreign keyturn on foreign keys check mysqlmysql alter add foreign keyforeign key mysqlmysql how to truncate table with foreign keyssql server find tables referenced foreign keysee foreign keymysql foreign keyhow delete foreign key in mysqltsql find foreign key referencesdrop foreign key mysqlmysql show foreign keys column
queries leading to this page
mysql find foreign key constraint namemysql see foreign keysfind foreign keys to mysqlfind foreign key references mysqlget foreign key by name mysqlhow to find foreign key constraint name in mysqlget all table with foreign key to table mysqlmysql get foreign keysmysql get foreign key referencescheck for foreign keys mysqlmysql find foreign key referenceshow to find foreign keys on a field mysqlget foreign keys mysqlget foreign key value mysqlmysql select foreign keymysql find values of foreign key constrainthow to see foreign key in mysqlget data of foreign key in mysqlgetting foreign key in mysqlfind by foreign key in mysqlmysql get foreign keys for tablemysql find foreign key issuesfind all foreign keys referencing a table mysqlmysql find foreign key constraintmysql find foreign key references