IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_EST_PROD_TRANSF_PRC_FILIAL1]'))
begin
	ALTER TABLE dbo.EST_PROD_TRANSF
		DROP CONSTRAINT FK_EST_PROD_TRANSF_PRC_FILIAL1
end
GO
ALTER TABLE dbo.EST_PROD_TRANSF ADD CONSTRAINT
	FK_EST_PROD_TRANSF_PRC_FILIAL1 FOREIGN KEY
	(
	CD_EMP,
	CD_FIL_DEST
	) REFERENCES dbo.PRC_FILIAL
	(
	CD_EMP,
	CD_FILIAL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 