카페힐링

1. 컬럼 정보 : SHOW FULL COLUMNS FROM TABLE_NAME;

2. 테이블, 컬럼 정보 : SYS.SYSTABLE

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';

3. 테이블의 코멘트(COMMENT) 정보: 

SELECT table_name
      ,table_comment
  FROM information_schema.tables
 WHERE table_schema = 'database_name' 
   AND table_name = 'table_name';