|
SQL
alter table GL_PZML drop constraint PK_GL_Pzml;
alter table GL_PZML alter column pzh varchar(10) not null;
alter table GL_PZML add constraint PK_GL_Pzml primary key (GSDM,ZTH,KJQJ,PZLY,PZLXDM,PZH);
UPDATE GL_PZML SET PZH=RTRIM(PZH);
alter table GL_Pzml_bk drop constraint PK_GL_Pzml_bk;
alter table GL_Pzml_bk alter column pzh varchar(10) not null;
alter table GL_Pzml_bk add constraint PK_GL_Pzml_bk primary key (GSDM,KJQJ,PZLY,PZLXDM,PZH)
UPDATE GL_Pzml_bk SET PZH=RTRIM(PZH);
alter table GL_PZNR drop constraint PK_GL_Pznr;
alter table GL_PZNR alter column pzh varchar(10) not null;
alter table GL_PZNR add constraint PK_GL_Pznr primary key (gsdm, kjqj, pzly, pzlxdm, pzh, flh, ZTH);
UPDATE GL_PZNR SET PZH=RTRIM(PZH);
alter table GL_PZNR_bk drop constraint PK_GL_PZNR_bk;
alter table GL_PZNR_bk alter column pzh varchar(10) not null;
alter table GL_PZNR_bk add constraint PK_GL_Pznr_bk primary key (GSDM,ZTH,KJQJ,PZLY,PZLXDM,PZH,FLH)
UPDATE GL_PZNR_bk SET PZH=RTRIM(PZH);
alter table GL_Pzflmx drop constraint PK_GL_Pzflmx;
alter table GL_Pzflmx alter column pzh varchar(10) not null;
alter table GL_Pzflmx add constraint PK_GL_Pzflmx primary key (gsdm, ZTH, kjqj, pzly, pzlxdm, pzh, flh, mxxh, mxlx)
UPDATE GL_Pzflmx SET PZH=RTRIM(PZH);
alter table GL_Pzflmx_bk drop constraint PK_GL_Pzflmx_bk;
alter table GL_Pzflmx_bk alter column pzh varchar(10) not null;
alter table GL_Pzflmx_bk add constraint PK_GL_Pzflmx_bk primary key (gsdm, ZTH, kjqj, pzly, pzlxdm, pzh, flh, mxxh, mxlx)
UPDATE GL_Pzflmx_bk SET PZH=RTRIM(PZH);
alter table GL_PZFJ drop constraint PK_GL_PZFJ;
alter table GL_PZFJ alter column pzh varchar(10) not null;
alter table GL_PZFJ add constraint PK_GL_PZFJ primary key (gsdm, ZTH, kjqj, pzlxdm, pzh, fjbh)
UPDATE GL_PZFJ SET PZH=RTRIM(PZH);
|
