IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('RC_CLI_COBRANCA') AND NAME = 'CD_BC')
BEGIN 
       ALTER TABLE RC_CLI_COBRANCA
       ADD CD_BC INT NULL DEFAULT 0


       ALTER TABLE RC_CLI_COBRANCA  ADD  CONSTRAINT FK_RC_CLI_COBRANCA_BC_BANCO FOREIGN KEY(CD_EMP,CD_BC)
       REFERENCES BC_BANCO(CD_EMP,CD_BC)
       ON UPDATE CASCADE
END 
 