bluebunny72 icon

Unique Constraint

bluebunny72 | PRO | 05/27/15 02:47:19 PM UTC | 0 ⭐ | 652 👁️ | Never ⏰ | []
T-SQL |

340 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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

Comments