
ALTER TABLE AKUZ.T_CDA_SVEDEN_RODAH_CHILDBIRTH ADD COLUMN "IdEhrColumn" INTEGER NULL;

UPDATE AKUZ.T_CDA_SVEDEN_RODAH_CHILDBIRTH child
SET "IdEhrColumn" = ehr.IdEHR 
FROM EHR.T_EHR_RUS_42Q2UOMG02 ehr
WHERE child.EhrRus42q2uomg02 = ehr.EhrRusID;

ALTER TABLE AKUZ.T_CDA_SVEDEN_RODAH_CHILDBIRTH DROP CONSTRAINT FK_T_EHR_RUS_42Q2UOMG02_T_CDA_SVEDEN_RODAH_CHILDBIRTH__D8299CC7;
ALTER TABLE AKUZ.T_CDA_SVEDEN_RODAH_CHILDBIRTH DROP COLUMN "ehrrus42q2uomg02";

ALTER TABLE AKUZ.T_CDA_SECTION_DOCINFO_SPORT DROP CONSTRAINT FK_T_EHR_RUS_VIDI_SPORTA_T_CDA_SECTION_DOCINFO_SPORT_E_D16F039E;
ALTER TABLE AKUZ.T_CDA_SECTION_DOCINFO_SPORT DROP COLUMN "ehrrusvidisporta";
