Answers for "check for foreign keys mysql"

turn on foreign keys check mysql

SET FOREIGN_KEY_CHECKS=0;

Posted by: Guest on April-24-2020

mysql find foreign key references

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME,   -- <<-- the one you want! 
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'My_Table';

Posted by: Guest on June-17-2021

Code answers related to "check for foreign keys mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "check for foreign keys mysql"

Code answers related to "check for foreign keys mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "check for foreign keys mysql"

Code answers related to "check for foreign keys mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us