use comments to show table and column documentation #mysql #snippet

table_doc.sql

-- table documentation
SELECT t.TABLE_SCHEMA, t.TABLE_NAME, t.TABLE_COMMENT
FROM TABLES t
WHERE t.TABLE_SCHEMA not in ('information_schema', 'mysql')
ORDER BY t.TABLE_SCHEMA, t.TABLE_NAME;



-- column documentation
SELECT c.TABLE_SCHEMA, c.TABLE_NAME, c.COLUMN_NAME, c.COLUMN_DEFAULT, c.COLUMN_TYPE, c.COLUMN_COMMENT
FROM information_schema.COLUMNS c
WHERE 
	c.TABLE_SCHEMA not in ('information_schema', 'mysql')
	-- and c.TABLE_NAME='t'
ORDER BY c.TABLE_SCHEMA, c.TABLE_NAME, c.ORDINAL_POSITION;