xlbruce/list-foreign-keys.sql

Created December 14, 2016 20:17

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

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

Download ZIP

List all tables that have a foreign key given a table name

Raw

list-foreign-keys.sql

	SELECT *
	FROM
	KEY_COLUMN_USAGE
	WHERE
	REFERENCED_TABLE_NAME = 'table_name'

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