search

awslabs / rds-support-tools

Amazon RDS Support Tools contains utilities, sql, scripts and views which are useful in a RDS environment
https://aws.amazon.com/rds/
Apache License 2.0
217 stars 229 forks source link

MySQL SQL to Check PKs #39

Closed marozzin closed 7 years ago

marozzin commented 7 years ago

Added MySQL SQL scripts to check PKs

check-table-pk.sql Report tables having Primary Key defined per schema per table Tested on MySQL 5.6

check-table-pk-columns.sql Report columns partecipating in Primary Key definition per schema per table Tested on MySQL 5.6