IF OBJECT_ID ('FK_RC_CLI_FIDELI_CARTAO_GLB_TP_FIDEL_LINXPROMO')IS NULL
BEGIN 
	ALTER TABLE [DBO].[RC_CLI_FIDELI_CARTAO] ADD  CONSTRAINT [FK_RC_CLI_FIDELI_CARTAO_GLB_TP_FIDEL_LINXPROMO] FOREIGN KEY([CD_EMP], [CD_TP_CARTAO]) REFERENCES GLB_TP_FIDEL_LINXPROMO ([CD_EMP], [CD_CTR])
	ALTER TABLE [DBO].[RC_CLI_FIDELI_CARTAO] CHECK CONSTRAINT [FK_RC_CLI_FIDELI_CARTAO_GLB_TP_FIDEL_LINXPROMO]
END 