修改表结构并给表字段添加备注

-- Add/modify columnsalter table T_CLAIM_PROPERTY_INFO add other_place VARCHAR2(3);alter table T_CLAIM_PROPERTY_INFO add disagree_easy_case VARCHAR2(2);-- Add comments to the columnscomment

ld513508088

7845人浏览 · 2014-02-26 17:35:43

ld513508088 · 2014-02-26 17:35:43 发布

-- Add/modify columns
alter table T_CLAIM_PROPERTY_INFO add other_place VARCHAR2(3);
alter table T_CLAIM_PROPERTY_INFO add disagree_easy_case VARCHAR2(2);
-- Add comments to the columns
comment on column T_CLAIM_PROPERTY_INFO.other_place
is '是否异地, 1是0否';
comment on column T_CLAIM_PROPERTY_INFO.disagree_easy_case
is '客户意愿1是0否';