/****** Object:  Index [IX_RC_CONC_PDV_VD_TEF]    Script Date: 08/15/2012 14:24:08 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[RC_CONC_PDV_VD_TEF]') AND name = N'IX_RC_CONC_PDV_VD_TEF')
ALTER TABLE dbo.RC_CONC_PDV_VD_TEF
	DROP CONSTRAINT IX_RC_CONC_PDV_VD_TEF
GO
GO

ALTER TABLE dbo.RC_CONC_PDV_VD_TEF ADD CONSTRAINT
	IX_RC_CONC_PDV_VD_TEF UNIQUE NONCLUSTERED 
	(
	CD_EMP,
	CD_FILIAL,
	CD_VD,
	CD_CTR
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
