如何用给表的每个列添加注释

[sql]代码库

-- Add comments to the table 
comment on table FTC_MATCH_CATEGORY
  is '比赛类目表';
-- Add comments to the columns 
comment on column FTC_MATCH_CATEGORY.ID
  is '主键，PK';
comment on column FTC_MATCH_CATEGORY.CN_SHORT_NAME
  is '简体中文简称';
comment on column FTC_MATCH_CATEGORY.CN_FULL_NAME
  is '简体中文全称';
comment on column FTC_MATCH_CATEGORY.EN_SHORT_NAME
  is '英文简称';
comment on column FTC_MATCH_CATEGORY.EN_FULL_NAME
  is '英文全称';
comment on column FTC_MATCH_CATEGORY.TD_SHORT_NAME
  is '繁体简称';
comment on column FTC_MATCH_CATEGORY.TD_FULL_NAME
  is '繁体全称';
comment on column FTC_MATCH_CATEGORY.CONTINENT
  is '所属区域';
comment on column FTC_MATCH_CATEGORY.GMT_MODIFIED
  is '最后修改时间';
comment on column FTC_MATCH_CATEGORY.ENABLED
  is '是否有效';
comment on column FTC_MATCH_CATEGORY.SEQ_NUM
  is '排序号';
comment on column FTC_MATCH_CATEGORY.HAS_CUP
  is '是否有杯赛';
comment on column FTC_MATCH_CATEGORY.HAS_LEA
  is '是否有联赛';
comment on column FTC_MATCH_CATEGORY.GMT_CREATE
  is '创建时间';
comment on column FTC_MATCH_CATEGORY.TYPE_KIND
  is '比赛类别：T_INTER-洲际赛事,T_EUR-欧洲赛事,T_AMER-美洲赛事,T_ASIA-亚洲赛事,T_OCE-大洋洲赛事,T_AFR-非洲赛事;';