IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS]') AND name = N'UQ_T_FPUMP_AMB_VISIT_DIAGNOSIS_Visit' and is_unique_constraint <> 1)
    DROP INDEX [UQ_T_FPUMP_AMB_VISIT_DIAGNOSIS_Visit] ON [AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS]

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS]') AND name = N'UQ_T_FPUMP_AMB_VISIT_DIAGNOSIS_Visit' and is_unique_constraint = 1)
    ALTER TABLE [AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS] DROP CONSTRAINT [UQ_T_FPUMP_AMB_VISIT_DIAGNOSIS_Visit]

IF  EXISTS (SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'[AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS]') AND name = N'Visit_UQ')
    ALTER TABLE [AKUZ].[T_FPUMP_AMB_VISIT_DIAGNOSIS] DROP COLUMN [Visit_UQ]
GO
