DB2 操作

---- 修改CUSTID, FUNDACCOUNTID, NAME, CERTTYPE, CERTCODE 为主键    AC.PARTNER_INFO
--删除主键
alter table AC.PARTNER_INFO drop primary key;


--删除parterid数据项
alter table AC.PARTNER_INFO drop column PARTNERID;


--增加资金账户状态字段
alter table AC.PARTNER_INFO add column FUNDACCOUNTID   BIGINT         NOT NULL WITH DEFAULT 0;
COMMENT ON COLUMN AC.PARTNER_INFO.FUNDACCOUNTID                       IS '资金账户Id';




db2 connect to ksdbs
db2 "reorg table ac.partner_info"
db2 "reorg table ac.his_partner_info"
db2 connect reset


--重新设置AC.PARTNER_INFO 主键
alter table AC.PARTNER_INFO add primary key (CUSTID, FUNDACCOUNTID, NAME, CERTTYPE, CERTCODE);