Show all constraints

by | Apr 1, 2016 | information_schema

This select shows all constraints for all tables in point of view of every table. So there are of course duplicities but we can see all constraints for table at once. select * from ( select CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG,...