MySQL: Difference between revisions

From Rixort Wiki
Jump to navigation Jump to search
No edit summary
Line 3: Line 3:
https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column
https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column


SELECT  
SELECT  
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
WHERE
  REFERENCED_TABLE_SCHEMA = 'database' AND
  REFERENCED_TABLE_SCHEMA = 'database' AND
  REFERENCED_TABLE_NAME = 'table';
  REFERENCED_TABLE_NAME = 'table';


== Links ==
== Links ==

Revision as of 14:23, 10 June 2019

Show foreign keys for a given table

https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column 

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = 'database' AND
  REFERENCED_TABLE_NAME = 'table';

Links

Retrieved from ‘https://wiki.rixort.com/index.php?title=MySQL&oldid=637’