MSSQL - Drop FK

dropfk.sql

SET NOCOUNT ON
GO

DECLARE Fkeys CURSOR FOR
SELECT 'ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']'
FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'

OPEN Fkeys

DECLARE @Statement NVARCHAR(500)

FETCH NEXT FROM Fkeys INTO @statement
WHILE (@@FETCH_STATUS = 0)
BEGIN
   PRINT N'RUNNING ' + @statement
   EXEC sp_executesql @statement
   PRINT CHAR(13) + CHAR(13)
   FETCH NEXT FROM Fkeys INTO @statement
END

CLOSE Fkeys
DEALLOCATE Fkeys
GO
SET NOCOUNT OFF
GO

select * FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'