/****** Object:  Index [IX_EST_NF_ENT_NFE_FORN_VALID_1]    Script Date: 09/12/2012 10:25:52 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[EST_NF_ENT_NFE_FORN_VALID]') AND name = N'IX_EST_NF_ENT_NFE_FORN_VALID_1')
ALTER TABLE [dbo].[EST_NF_ENT_NFE_FORN_VALID] DROP CONSTRAINT [IX_EST_NF_ENT_NFE_FORN_VALID_1]
GO

/****** Object:  Index [IX_EST_NF_ENT_NFE_FORN_VALID_1]    Script Date: 16/04/2014 18:21:55 ******/
ALTER TABLE [dbo].[EST_NF_ENT_NFE_FORN_VALID] ADD  CONSTRAINT [IX_EST_NF_ENT_NFE_FORN_VALID_1] UNIQUE NONCLUSTERED 
(
	[NR_NF] ASC,
	[DT_EMI_NF] ASC,
	[CD_FORN] ASC,
	[CD_FILIAL] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


