declare @masterTable sysname = 'tbl_MASTER';
declare @newMasterTable sysname = '[dbo].[tbl_MASTER2]';
declare @sql1 nvarchar(max) = N'';
declare @sql2 nvarchar(max) = N'';

select @sql1 += formatmessage('alter table %s drop constraint %s;', quotename(object_schema_name([parent_object_id])) + N'.' + quotename(object_name([parent_object_id])), quotename([name])) + nchar(13) + nchar(10)
from sys.foreign_keys
where [referenced_object_id] = object_id(@masterTable, 'U');




select @sql2 += formatmessage('alter table %s add constraint %s foreign key (%s) references %s (%s)', 
                              quotename(object_schema_name([parent_object_id])) + N'.' + quotename(object_name([parent_object_id])),
                              quotename(quotename(object_name([constraint_object_id]))),
                              col_name([parent_object_id], [parent_column_id]),
                              @newMasterTable,
                              quotename(col_name([referenced_object_id], [referenced_column_id]))) + nchar(13) + nchar(10)
from sys.foreign_key_columns
where [referenced_object_id] = object_id(@masterTable, 'U')

select @sql1;
select @sql2;

--exec(@sql1);
--exec(@sql2);