-- Drop and recreate the FK with CASCADE
ALTER TABLE [dbo].[ERPCountryCode]
DROP CONSTRAINT [FK_ERPCountryCode_CountryCode]
Go

ALTER TABLE [dbo].[ERPCountryCode]
ADD CONSTRAINT [FK_ERPCountryCode_CountryCode]
FOREIGN KEY ([CountryCode_Id])
REFERENCES [dbo].[CountryCode]([Id])
ON UPDATE No Action
ON DELETE No Action
Go