• A Diagram of the MySQL information schema
  • http://www.xcdsql.org/MySQL/information_schema/5.1/MySQL_5_1_INFORMATION_SCHEMA.html
• find primary key of table

SELECT c.*, ke.REFERENCED_TABLE_NAME FROM
information_schema.COLUMNS c LEFT JOIN
information_schema.KEY_COLUMN_USAGE ke
USING (TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME)
WHERE
c.table_schema='test'
ORDER BY
ke.referenced_table_name;

got Tables, Primary Keys and Foreign Keys to display…