IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[PDV_CX_NFCE_CERTIFICADO]') AND name = N'PK_PDV_CX_NFCE_CERTIFICADO')

ALTER TABLE PDV_CX_NFCE_CERTIFICADO DISABLE CHANGE_TRACKING;
ALTER TABLE [dbo].[PDV_CX_NFCE_CERTIFICADO] DROP CONSTRAINT [PK_PDV_CX_NFCE_CERTIFICADO] WITH(ONLINE = OFF);
GO
ALTER TABLE [dbo].[PDV_CX_NFCE_CERTIFICADO]
ADD CONSTRAINT [PK_PDV_CX_NFCE_CERTIFICADO] PRIMARY KEY CLUSTERED([CD_CTR] 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) ON [PRIMARY];
GO
ALTER TABLE PDV_CX_NFCE_CERTIFICADO ENABLE CHANGE_TRACKING;
