SELECT 'ALTER TABLE [dbo].[' +''+ object_name(fk.parent_object_id)+']' AS ParentTableName,
'WITH NOCHECK ADD CONSTRAINT'+' ['+ fk.[name] +']' ,
'FOREIGN KEY([' +''+ COL_NAME(fc.parent_object_id,fc.parent_column_id) +'])' AS ParentColName ,
'REFERENCES [dbo].[' +''+ object_name(fk.referenced_object_id) +']' AS RefTableName,
'([' +''+ COL_NAME(fc.referenced_object_id,fc.referenced_column_id) +'])' AS RerfColName ,
' NOT FOR REPLICATION'
FROM sys.foreign_keys fk
INNER JOIN sys.foreign_key_columns AS fc
ON fk.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.tables t
ON t.OBJECT_ID = fc.referenced_object_id
--WHERE fc.parent_object_id = object_id('Table_name')