Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Check for missing FK indexes SELECT fk.TABLE_NAME, fk.COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE fk LEFT JOIN information_schema.STATISTICS s ON s.TABLE_NAME = fk.TABLE_NAME AND s.COLUMN_NAME = fk.COLUMN_NAME WHERE fk.REFERENCED_TABLE_NAME IS NOT NULL AND s.INDEX_NAME IS NULL;
Result
Open