ques0942/file0.sql

Created May 17, 2018 11:20

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

Download ZIP

よく使うinformation_schemaのテーブルまとめ ref: https://qiita.com/ques0942/items/f98968de8968822ecf5c

Raw

	select
	*
	from information_schema.referential_constraints rc
	inner join information_schema.statistics s
	on rc.constraint_name = s.index_name

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