Skip to content

Instantly share code, notes, and snippets.

@anytizer

anytizer/table-comments.sql

Created March 22, 2016 08:59
Show Gist options
  • Save anytizer/36031ab471055f8654e2 to your computer and use it in GitHub Desktop.
Save anytizer/36031ab471055f8654e2 to your computer and use it in GitHub Desktop.
Download ZIP
Comments in the tables
Raw
table-comments.sql
SELECT
TABLE_NAME, TABLE_COMMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA=DATABASE()
AND TABLE_TYPE='BASE TABLE'
ORDER BY
TABLE_NAME
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment