GO
CREATE PROCEDURE uspDropUserForeignKeys

AS

SET NOCOUNT ON
DECLARE @strMessage       VARCHAR(250)  
DECLARE @strForeignKey    VARCHAR(250)
DECLARE @strChildTable    VARCHAR(250)
DECLARE @strCommand       VARCHAR(250)
DECLARE @strTab           CHAR = CHAR(9)

---------------------Drop all user foreign keys------------------------

PRINT @strTab + 'DROP ALL USER FOREIGN KEYS ...'

DECLARE crsForeignKeys CURSOR FOR
SELECT
       name     AS strForeignKey
      ,OBJECT_NAME(parent_obj)  AS strChildTable
FROM
    sysobjects

WHERE
      xtype='F'    /* Foreign Keys Only */
    AND (
           name LIKE '%_FK'
        OR name LIKE '%_FK_'
        )
    AND OBJECT_NAME(parent_obj) LIKE 'T%'

ORDER BY
    name

OPEN crsForeignKeys
FETCH NEXT FROM crsForeignKeys INTO @strForeignKey, @strChildTable


-- Loop until no more records
WHILE @@FETCH_STATUS = 0
BEGIN

     SELECT @strMessage = @strTab + @strTab + '—DROP ' + @strForeignKey
     PRINT @strMessage


--   Build command
     SELECT @strCommand = 'ALTER TABLE' + @strChildTable + 'DROP CONSTRAINT' + @strForeignKey

--  Execute command
     EXECUTE(@strCommand)
	
     FETCH NEXT FROM crsForeignKeys INTO @strForeignKey, @strChildTable

END

-- Clean up
CLOSE crsForeignKeys
DEALLOCATE crsForeignKeys

PRINT @strTab + 'DONE'
GO