Oracle 数据库 表添加新字段加备注

alter table M_METER_INFO add (
TENEMENTGUID VARCHAR2(36),
CREATEDBY VARCHAR2(36),
CREATEDDATE DATE,
MODIFIEDBY VARCHAR2(36),
MODIFIEDDATE DATE
);
comment on column TENEMENTGUID is '租户guid';
comment on column CREATEDBY is '添加人';
comment on column CREATEDDATE is '添加时间';
comment on column MODIFIEDBY is '修改人';
comment on column MODIFIEDDATE is '修改时间';
commit;

 

posted @ 2018-05-30 09:41  lwlr  阅读(18412)  评论(0编辑  收藏  举报