Monday, 9 February 2015

Finding cross references (from foreign keys)

SELECT *
FROM
  information_schema.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'GameCompany'
  AND REFERENCED_COLUMN_NAME = 'Id'
  AND TABLE_SCHEMA = 'Stick';

No comments:

Post a Comment