IF OBJECT_ID('AKUZ.T_SUM_PRESCRIBDRUG_SPECINSTRUCTION', 'U') IS NOT NULL 
  DROP TABLE AKUZ.T_SUM_PRESCRIBDRUG_SPECINSTRUCTION 
GO

ALTER TABLE [AKUZ].[T_SUM_SECTIONS_SPECINSTRUCTION] ADD [SumPrescribdrugInstruction] uniqueidentifier NULL
GO

ALTER TABLE [AKUZ].[T_SUM_SECTIONS_SPECINSTRUCTION] ADD [SpecInstruction] varchar(4096) NOT NULL CONSTRAINT [df_SpecInstruction] DEFAULT '' WITH VALUES
GO
ALTER TABLE [AKUZ].[T_SUM_SECTIONS_SPECINSTRUCTION] DROP CONSTRAINT [df_SpecInstruction]
GO

ALTER TABLE [AKUZ].[T_SUM_SECTIONS_SPECINSTRUCTION] ADD CONSTRAINT [FK_T_SUM_PRESCRIBDRUG_INSTRUCTION_T_SUM_SECTIONS_SPECINSTRUCTION_SumPrescribdrugInstruction]
FOREIGN KEY([SumPrescribdrugInstruction]) REFERENCES [AKUZ].[T_SUM_PRESCRIBDRUG_INSTRUCTION] ([SumPrescribdrugInstructionID])
GO

