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; 1. 'First Drop contrstraints like this' ALTER TABLE table_name DROP CONSTRAINT constraint_name; 2. 'Then drop table' DROP TABLE table_name;ALTER TABLE Azure_Policy_User DROP CONSTRAINT FK_Azure_Policy_User_UserID;