/****** Object:  Index [IX_EST_NF_ENT_PED_CP_1]    Script Date: 04/02/2015 14:05:57 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[EST_NF_ENT_PED_CP]') AND name = N'IX_EST_NF_ENT_PED_CP_1')

ALTER TABLE [dbo].[EST_NF_ENT_PED_CP] DROP CONSTRAINT [IX_EST_NF_ENT_PED_CP_1]
GO

ALTER TABLE dbo.EST_NF_ENT_PED_CP ADD CONSTRAINT IX_EST_NF_ENT_PED_CP_1 UNIQUE NONCLUSTERED 
(
	CD_NF,
	CD_FILIAL,
	CD_EMP
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO