TABLE/COLUMN COMMENT

COMMENT 조회·설정

SHOW TABLE STATUS;
SHOW FULL COLUMNS FROM table_name;

SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_COMMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db';

SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'db' AND TABLE_NAME = 't';

ALTER TABLE t COMMENT = '테이블 설명';
ALTER TABLE t CHANGE col col INT NULL COMMENT '컬럼 설명';