DYNAMIC DDL FOREIGN KEY DEFFINITIONS FROM SYSTEM VIEWS

gistfile1.sql

SELECT DISTINCT 'ALTER TABLE ' + QUOTENAME(SCHEMA_NAME(pt.schema_id) )+ '.' + QUOTENAME(pt.name) 
	+ CASE FK.is_disabled WHEN 1 THEN ' WITH NOCHECK ' ELSE ' WITH CHECK ' END 
	+ 'ADD CONSTRAINT ' + QUOTENAME(fk.name) + ' FOREIGN KEY (' + ptc.ColumnList + ') '
	+ 'REFERENCES ' + QUOTENAME(SCHEMA_NAME(rt.Schema_id)) + '.' + QUOTENAME(rt.name) 
	+ ' (' + rtc.ColumnList + ')'
FROM sys.foreign_keys fk
	INNER JOIN sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id
	INNER JOIN sys.tables pt ON pt.object_id = fk.parent_object_id
	INNER JOIN sys.tables rt ON rt.object_id = fkc.referenced_object_id
	CROSS APPLY (SELECT DISTINCT STUFF((SELECT ', ' +  QUOTENAME(c.name) 
				FROM sys.foreign_key_columns fkc 
					INNER JOIN sys.columns c 
						ON c.object_id = fkc.parent_object_id
							AND c.column_id = fkc.parent_column_id
				WHERE fkc.constraint_object_id = fk.object_id
				ORDER BY fkc.constraint_column_id
				FOR XML PATH('')),1,1,'') AS ColumnList
				)ptc 
	CROSS APPLY (SELECT DISTINCT STUFF((SELECT ', ' +  QUOTENAME(c.name) 
				FROM sys.foreign_key_columns fkc 
					INNER JOIN sys.columns c 
						ON c.object_id = fkc.referenced_object_id
							AND c.column_id = fkc.referenced_column_id
				WHERE fkc.constraint_object_id = fk.object_id
				ORDER BY fkc.constraint_column_id
				FOR XML PATH('')),1,1,'') AS ColumnList
				)rtc