/****** Object:  Index [IX_EST_NF_ENT_NFE_FORN_VALID_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_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: 04/02/2015 14:06:16 ******/
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,
	[NR_AUTORIZADOR] 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, FILLFACTOR = 90) ON [PRIMARY]
GO


