DECLARE @sql NVARCHAR(MAX) = '';
-- Remove foreign key constraints from Students table that reference Classes
SELECT @sql += 'ALTER TABLE ' + QUOTENAME(FK.TABLE_SCHEMA) + '.' + QUOTENAME(FK.TABLE_NAME)
+ ' DROP CONSTRAINT ' + QUOTENAME(FK.CONSTRAINT_NAME) + '; '
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
WHERE FK.TABLE_NAME = 'Students' AND C.UNIQUE_CONSTRAINT_NAME IN (
SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'Classes'
);
-- Remove foreign key constraints from Classes table that reference Students
SELECT @sql += 'ALTER TABLE ' + QUOTENAME(FK.TABLE_SCHEMA) + '.' + QUOTENAME(FK.TABLE_NAME)
+ ' DROP CONSTRAINT ' + QUOTENAME(FK.CONSTRAINT_NAME) + '; '
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
WHERE FK.TABLE_NAME = 'Classes' AND C.UNIQUE_CONSTRAINT_NAME IN (
SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'Students'
);
EXEC sp_executesql @sql;