Skip to content

Instantly share code, notes, and snippets.

@vladimir-light

vladimir-light/get_all_constraints_from_current_db.sql

Last active August 29, 2015 14:11
Show Gist options
  • Save vladimir-light/9dec17d20e82bb997f1a to your computer and use it in GitHub Desktop.
Save vladimir-light/9dec17d20e82bb997f1a to your computer and use it in GitHub Desktop.
Download ZIP
Find / Check All Foreign Keys of a DataBase
Raw
get_all_constraints_from_current_db.sql
SELECT
constraint_name,
table_name
FROM
information_schema.table_constraints
WHERE
constraint_type = 'FOREIGN KEY'
AND table_schema = DATABASE()
ORDER BY
constraint_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment