powerdesigner 生成oracle,PowerDesigner 生成Oracle comment 备注

环境：PowerDesigner 15.1.0.2850，oracle 11g

如需生成的表与表字段有comment(备注)，钩选上红色框标识的checkbox.

操作菜单: Database->Generat Database ->Format

生成后脚本：

/*==============================================================*/

/* Table: "t_apply" */

/*==============================================================*/

create table "t_apply" (

"id" NUMBER,

"apply_num" NUMERIC,

"apply_name" VARCHAR2(100),

"apply_code" VARCHAR2(100),

"apply_state" CHAR(1),

"apply_time" DATE,

"apply_person_code" VARCHAR2(100),

"apply_person_name" VARCHAR2(100),

"apply_remark" VARCHAR2(1000)

);

comment on table "t_apply" is

'申请表';

comment on column "t_apply"."id" is

'id';

comment on column "t_apply"."apply_num" is

'申请编号';

comment on column "t_apply"."apply_name" is

'申请事项名称';

comment on column "t_apply"."apply_code" is

'申请事项代码';

comment on column "t_apply"."apply_state" is

'状态';

comment on column "t_apply"."apply_time" is

'申请时间';

comment on column "t_apply"."apply_person_code" is

'申请人代码';

comment on column "t_apply"."apply_person_name" is

'申请人名称';

comment on column "t_apply"."apply_remark" is

'申请说明';