galvao/fk_query.sql

Created October 16, 2013 07:05

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/galvao/7003758.js"></script>
Save galvao/7003758 to your computer and use it in GitHub Desktop.

Download ZIP

Querying for Foreign Key Constraints in a MySQL Database

Raw

fk_query.sql

	SELECT
	*
	FROM
	information_schema.referential_constraints
	WHERE
	table_name='<table_name>'
	AND constraint_schema='<database_name>';

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