-- Tables

-- Alters


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[AKUZ].[FK_T_CDA_SECTION_DONATEDBLOODINFO_HEMOTRANSFUSION_T_CDA_SVEDEN_OB_HEMOTRANSFUSION_CdaSectionDonatedbloodinfoHemotransfusion]') AND parent_object_id = OBJECT_ID(N'[AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION]'))
ALTER TABLE [AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION] DROP CONSTRAINT [FK_T_CDA_SECTION_DONATEDBLOODINFO_HEMOTRANSFUSION_T_CDA_SVEDEN_OB_HEMOTRANSFUSION_CdaSectionDonatedbloodinfoHemotransfusion]

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION]') AND name = N'UQ_T_CDA_SVEDEN_OB_HEMOTRANSFUSION_CdaSectionDonatedbloodinfoHemotransfusion')
DROP INDEX [UQ_T_CDA_SVEDEN_OB_HEMOTRANSFUSION_CdaSectionDonatedbloodinfoHemotransfusion] ON [AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION]

ALTER TABLE [AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION] DROP COLUMN CdaSectionDonatedbloodinfoHemotransfusion_UQ
ALTER TABLE [AKUZ].[T_CDA_SVEDEN_OB_HEMOTRANSFUSION] DROP COLUMN CdaSectionDonatedbloodinfoHemotransfusion

GO