문서의 이전 판입니다!
SHOW TABLE STATUS;
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='database_name';
SELECT TABLE_SCHEMA,TABLE_NAME,AUTO_INCREMENT,TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='database_name';
SHOW FULL COLUMNS FROM TABLE_NAME;
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='database_name';
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,COLUMN_DEFAULT ,DATA_TYPE,COLUMN_TYPE,COLUMN_KEY,EXTRA,COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='database_name' AND TABLE_NAME='table_name';
CREATE TABLE TABLE_NAME ( 컬럼1 INT, ... ) COMMENT = 'comment';
ALTER TABLE TABLE_NAME COMMENT = '테이블설명';