mysql show foreign keys column

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

Search
showing results for - "mysql show foreign keys column"
Gabrielle
09 Oct 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>' AND
8  REFERENCED_COLUMN_NAME = '<column>';
source
similar questions
get foreign table names mysqlhow delete foreign key in mysqlmysql foreign key constraintsmysql show column data typesmysql disable foreign key checksmysql show foreign keyshow to connect database foreign key in mysqlturn on foreign keys check mysqladd column mysql with foreign keyupdate foreign key value in mysqlmysql modify foreign keymysql get primary keys of tablemysql show table character setmysql find foreign key referencescreate table mysql with foreign keymysql set foreign key checks 3d0mysql foreign keyalter table add foreign key mysqlforeign key mysqlalter table add column and foreign key mysqlget the mysql table columns data type mysqlmysql add foreign keyshow table columns mysql command linemysql show table fieldsforeign key type uniqu mysqlmysql alter add foreign key
queries leading to this page
mysql to display foreign keymysql show foreign keyshow foreign key mysql commandshow foreign key table mysqlshow all foreign keys mysqlshow all foreign key constraint mysqlsee foreign keys in mysqlshow data according to foreign key in mysqlmysql view foreign key from tablehow to see foreign key constraint in mysqlhow to see all foreign keys in mysqlmysql show foreign keys listsmysql show foreign keysshow foreign key mysqlmysql show foreign keys column