kvn1234/foreign_keys

Created August 10, 2018 17:15

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kvn1234/d18c093ce7a8f72a5d41a79e6501b297.js"></script>
Save kvn1234/d18c093ce7a8f72a5d41a79e6501b297 to your computer and use it in GitHub Desktop.

Download ZIP

Find foreign keys from information_schema

Raw

foreign_keys

SELECT * FROM KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = 'table_name' AND REFERENCED_COLUMN_NAME = 'id'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment