mysql TABLE 커멘트 컬럼명 컬럼 커멘트 조회

SELECT A.TABLE_NAME

       , A.TABLE_COMMENT

       , B.COLUMN_NAME

       , B.COLUMN_COMMENT

       , B.IS_NULLABLE

       , B.EXTRA
  FROM INFORMATION_SCHEMA.TABLES A

  INNER JOIN

        INFORMATION_SCHEMA.COLUMNS B

    on (A.TABLE_CATALOG = B.TABLE_CATALOG  AND A.TABLE_SCHEMA = B.TABLE_SCHEMA AND A.TABLE_NAME = B.TABLE_NAME)

WHERE TABLE_SCHEMA = '스키마'
   AND COLUMN_NAME = '컬럼명'