ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_STAGE] ALTER COLUMN [PersonId] varchar(14) NOT NULL
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP] ALTER COLUMN [PersonId] varchar(14) NOT NULL
GO

ALTER TABLE [AKUZ].[T_FRVICH_REGISTRATION_RECORD] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_REGISTRATION_RECORD_TubMkbAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_REGISTRATION_RECORD] DROP COLUMN [TubMkbAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_HOSP] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_HOSP_FinalMkbAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_HOSP] DROP COLUMN [FinalMkbAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_CONC] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_CONC_ConcDeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_CONC] DROP COLUMN [ConcDeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_CHEKUP] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_CHEKUP_DeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP_CHEKUP] DROP COLUMN [DeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_DeathDeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP] DROP CONSTRAINT [FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_DeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP] DROP COLUMN [DeathDeseaseAsMkb308]
GO

ALTER TABLE [AKUZ].[T_FRVICH_HIV_DISP] DROP COLUMN [DeseaseAsMkb308]
GO