Unique Constraint

IF  EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UQ_dept_Uf_ILC_CostCodeType]') AND type = N'UQ')
    ALTER TABLE [dbo].[dept] DROP CONSTRAINT [UQ_dept_Uf_ILC_CostCodeType]
GO

ALTER TABLE [dbo].[dept] ADD  CONSTRAINT [UQ_dept_Uf_ILC_CostCodeType] UNIQUE NONCLUSTERED
(
       [Uf_ILC_CostCodeType] ASC
)
GO