Skip to content

Instantly share code, notes, and snippets.

@dan-palmer

dan-palmer/view-mysql-table-constraints.sql

Created December 12, 2012 15:32
Show Gist options
  • Save dan-palmer/4268727 to your computer and use it in GitHub Desktop.
Save dan-palmer/4268727 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
view-mysql-table-constraints.sql
SELECT * FROM information_schema.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_NAME = 'TABLE_NAME_HERE';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment