9 lines
380 B
SQL
9 lines
380 B
SQL
ALTER TABLE CAPPRESMS ADD ACC_NO VARCHAR2(32) default ' ' not null;
|
|
|
|
|
|
ALTER TABLE CAPPRESMS DROP CONSTRAINT CAPPRESMS_PK;
|
|
ALTER TABLE CAPPRESMS ADD CONSTRAINT CAPPRESMS_PK primary key (FSYS_ID, CAP_TYP, MBL_NO,ACC_NO);
|
|
|
|
ALTER TABLE CAPPREBAL DROP CONSTRAINT CAPPREBAL_PK;
|
|
ALTER TABLE CAPPREBAL ADD CONSTRAINT CAPPREBAL_PK primary key (FSYS_ID, CAP_TYP, BNK_ORG,ACC_NO);
|