IF EXISTS (SELECT * FROM SYS.INDEXES WHERE NAME = 'IDX_RC_ADM_CARTAO_MOV_LOTE_PDV_VD')
BEGIN   
 DROP INDEX [IDX_RC_ADM_CARTAO_MOV_LOTE_PDV_VD] ON [dbo].[RC_ADM_CARTAO_MOV_LOTE_PDV_VD]
END
GO
IF NOT EXISTS (SELECT * FROM SYS.INDEXES WHERE NAME = 'IDX_RC_ADM_CARTAO_MOV_LOTE_PDV_VD')
BEGIN
CREATE NONCLUSTERED INDEX IDX_RC_ADM_CARTAO_MOV_LOTE_PDV_VD
ON [dbo].[RC_ADM_CARTAO_MOV_LOTE_PDV_VD] ([CD_EMP],[CD_FILIAL],[CD_VD],[CD_CTR])
END