mysql - How do I see all foreign keys to a table or column?

In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular column? This is the same thing as this Oracle question, but for MySQL.

Answer

For a Table:

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE

  REFERENCED_TABLE_SCHEMA = '' AND
  REFERENCED_TABLE_NAME = '';


For a Column:

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE

WHERE
  REFERENCED_TABLE_SCHEMA = '' AND
  REFERENCED_TABLE_NAME = '
' AND
  REFERENCED_COLUMN_NAME = '';


Basically, we changed REFERENCED_TABLE_NAME with REFERENCED_COLUMN_NAME in the where clause.


Subscribe to:
Post Comments (Atom)



casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? -
Movies & TV

In the Spider-Man franchise, Tobey Maguire  is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...









c++ - Qt project in Visual Studio 2015: "unresolved external symbol
wWinMain"
The whole error output being: LNK2019 unresolved external symbol wWinMain referenced in function "int __cdecl __scrt_common_main_seh(vo...





express - Request header field Access-Control-Allow-Headers is not
allowed by itself in preflight response
I have come across CORS issues multiple times and can usually fix it but I want to really understand by seeing this from a MEAN stack paradi...





Javascript load Image into Offscreen Canvas, perform webp conversion
I recently used canvas to conert images to webp, using : const dataUrl = canvas.toDataURL('image/webp'); But this takes a lots of ti...















Search This Blog