/****** Object:  Index [IX_PDV_CONSLD_VD_CX_PENDENTE]    Script Date: 10/10/2013 16:03:20 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[PDV_CONSLD_VD_CX_PENDENTE]') AND name = N'IX_PDV_CONSLD_VD_CX_PENDENTE' AND TYPE  =2 )
ALTER TABLE [dbo].[PDV_CONSLD_VD_CX_PENDENTE] DROP CONSTRAINT [IX_PDV_CONSLD_VD_CX_PENDENTE]
GO
ALTER TABLE [dbo].[PDV_CONSLD_VD_CX_PENDENTE] ADD  CONSTRAINT [IX_PDV_CONSLD_VD_CX_PENDENTE] UNIQUE NONCLUSTERED 
(
	[DT_VD] ASC,
	[CD_CX] ASC,
	[CD_FILIAL] ASC,
	[TP_CUPOM] ASC,
	[CD_EMP] 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]

