mysql show foreign keys

Solutions on MaxInterview for mysql show foreign keys by the best coders in the world

Search
showing results for - "mysql show foreign keys"
Luis
14 Nov 2019
1SELECT 
2  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
3FROM
4  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
5WHERE
6  REFERENCED_TABLE_SCHEMA = '<database>' AND
7  REFERENCED_TABLE_NAME = '<table>';
source
Ester
09 Oct 2017
1SELECT 
2  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
3FROM
4  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
5WHERE
6  REFERENCED_TABLE_SCHEMA = '<database>' AND
7  REFERENCED_TABLE_NAME = '<table>' AND
8  REFERENCED_COLUMN_NAME = '<column>';
source
similar questions
fk in insert mysqlmysql add foreign keymysql foreign key constraintscreate table mysql with foreign keyforeign key type uniqu mysqlmysql show table fieldsmysql remove foreign key constraintmysql disable foreign key checkshow 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 mysqlmysql find foreign key referencesmysql modify foreign keyturn on foreign keys check mysqlmysql alter add foreign keyforeign key mysqlmysql get primary keys of tablemysql foreign keydrop all foreign key constraints mysqlhow delete foreign key in mysqldrop foreign key mysql
queries leading to this page
mysql show foreign keysmysql check foreign key constraintslist foreign key constraint mysqlhow to see all foreign keys in mysqlfind foreign keys to mysqlshow foreign key table mysqlmysql command show foreign keys referencing tableshow all foreign key constraint mysqlmysql show foreign keys listsshow all foreign keys mysqlget foreign keys mysqlshow foreign key mysql commandsee foreign keys in mysqlcheck for foreign key in mysql tablemysql show foreign keymysql to display foreign keyview foreign key constraint mysqlmysql view foreign key from tablehow to see foreign key constraint in mysqlshow data according to foreign key in mysqlsee syntax foreign key mysqlmysql list all foreign keys columnhow do i check foreign keys in a table mysqlget data of foreign key in mysqlhow to see foreign key relation in mysqlmysql set foreign key checks offhow to see foreign keys constaints in mysqlmysql show foreign keys