PowerDesigner 生成Oracle comment 备注

来源：互联网发布：ubuntu命令行安装jdk 编辑：程序博客网时间：2024/05/16 12:44

环境：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'申请说明';

0 0