Documenting Your MySQL Data Warehouse

mysql.sql

create table orders(id int) comment="This table holds all customer orders!";

select table_comment 
from information_schema.tables
where table_name='orders';
┌───────────────────────────────────────┐
│              table_comment            │
├───────────────────────────────────────┤
│ This table holds all customer orders! │
└───────────────────────────────────────┘