USE [MoriFarmaProducao]
GO

/****** Object:  Index [IX_EST_NF_ENT_NR_NAO_DUPLICAR]    Script Date: 02/23/2012 17:03:43 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[EST_NF_ENT]') AND name = N'IX_EST_NF_ENT_NR_NAO_DUPLICAR')
DROP INDEX [IX_EST_NF_ENT_NR_NAO_DUPLICAR] ON [dbo].[EST_NF_ENT] WITH ( ONLINE = OFF )
GO

USE [MoriFarmaProducao]
GO

/****** Object:  Index [IX_EST_NF_ENT_NR_NAO_DUPLICAR]    Script Date: 02/23/2012 17:03:49 ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_EST_NF_ENT_NR_NAO_DUPLICAR] ON [dbo].[EST_NF_ENT] 
(
	[NR_NF] ASC,
	[DT_EMI_NF] ASC,
	[CD_FORN] ASC,
	[CD_FILIAL] ASC,
	[CD_EMP] ASC,
	[CD_NF_SERIE] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


