SELECT
a.TABLE_NAME '테이블명',
b.ORDINAL_POSITION '순번',
b.COLUMN_NAME '필드명',
b.DATA_TYPE 'DATA TYPE',
b.COLUMN_TYPE '데이터길이',
b.COLUMN_KEY 'KEY',
b.IS_NULLABLE 'NULL값여부',
b.EXTRA '자동여부',
b.COLUMN_DEFAULT '디폴트값',
b.COLUMN_COMMENT '필드설명'
FROM information_schema.TABLES a
JOIN information_schema.COLUMNS b ON a.TABLE_NAME = b.TABLE_NAME AND a.TABLE_SCHEMA = b.TABLE_SCHEMA
WHERE a.TABLE_SCHEMA = 'DB_NAME'
ORDER BY
a.TABLE_NAME, b.ORDINAL_POSITION