-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_MEDICAL_EXAMINATION_DATA] ALTER COLUMN [Diagnosis] varchar(4096) NULL
GO
UPDATE [AKUZ].[T_MEDICAL_EXAMINATION_DATA] SET [Diagnosis] = '' WHERE [Diagnosis] IS NULL
GO
ALTER TABLE [AKUZ].[T_MEDICAL_EXAMINATION_DATA] ALTER COLUMN [Diagnosis] varchar(4096) NOT NULL
GO


ALTER TABLE [AKUZ].[T_MEDICAL_EXAMINATION_DATA] ALTER COLUMN [VisitPurpose] uniqueidentifier NULL
GO