Recreate certain constraints with delete CASCADE

DropCreate_ConstraintsCascade.sql

SELECT 
'
IF EXISTS(
	SELECT rc.*
	FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS rc 

	LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU1 
		ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG  
		AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA 
		AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME 
		
	WHERE KCU1.TABLE_NAME = ''' + REPLACE(FK_TABLE_NAME, '''', '''''') + ''' 
	AND rc.CONSTRAINT_NAME = ''' + REPLACE(FK_CONSTRAINT_NAME, '''', '''''') + ''' 
	AND rc.CONSTRAINT_SCHEMA = ''dbo'' 
) 
ALTER TABLE "dbo"."' + REPLACE(FK_TABLE_NAME, '''', '''''') + '" DROP CONSTRAINT "' + REPLACE(FK_CONSTRAINT_NAME, '''', '''''') + '"
GO



ALTER TABLE "dbo"."' + REPLACE(FK_TABLE_NAME, '''', '''''') + '"  WITH NOCHECK 
ADD CONSTRAINT "' + REPLACE(FK_CONSTRAINT_NAME, '''', '''''') + '" FOREIGN KEY("' + REPLACE(FK_COLUMN_NAME, '''', '''''') + '") 
REFERENCES "dbo"."' + REPLACE(REFERENCED_TABLE_NAME, '''', '''''') + '" ("' + REPLACE(REFERENCED_COLUMN_NAME, '''', '''''') + '") 
ON DELETE CASCADE 
GO

ALTER TABLE "dbo"."' + REPLACE(FK_TABLE_NAME, '''', '''''') + '" CHECK CONSTRAINT "' + REPLACE(FK_CONSTRAINT_NAME, '''', '''''') + '" 
GO
' AS cmd 

FROM V_DELDATA_ForeignKeyRelations 

WHERE (1=1) 
-- AND FK_TABLE_NAME = 'T_SYS_Aussenobjektrechte'
AND FK_COLUMN_NAME LIKE '%_GRANTEE_ID'

ORDER BY FK_TABLE_NAME, FK_COLUMN_NAME