Tabloya ait constraintleri silmek istiyorsunuz ama tek tek yapmak sıkıcı ve zor

Tabloya ait constraintleri silmek istiyorsunuz ama tek tek yapmak sıkıcı ve zor. o halde bu script işinizi görür.

SET NOCOUNT ON
SET ROWCOUNT 0

DECLARE @Count int
DECLARE @String nvarchar (1000)
DECLARE @ConstraintName varchar(128)
DECLARE @TableName varchar(128)

SELECT
        name                     AS constraintname,
        object_name(parent_obj)  AS tablename
INTO #Const_Table
FROM sysobjects s
where xtype in ('F')
and
(
object_name(parent_obj)='CekSenet'
or
name like '%ÇekSenetFK'
or
object_name(parent_obj)='Malzeme'
or
name like '%MalzemeFK'
)
SELECT @Count = Count(*) FROM #Const_Table

SET ROWCOUNT 1

WHILE @Count > 0
BEGIN
    
    SELECT @TableName = TableName, @ConstraintName = ConstraintName
    FROM #Const_Table

    print cast(@Count as varchar(10))+'-'+@ConstraintName

    SET @String = 'ALTER TABLE ['+ @tablename + '] DROP CONSTRAINT [' + @constraintname +']'

    exec sp_executesql @string

    DELETE FROM #Const_Table WHERE ConstraintName = @ConstraintName and TableName = @TableName

    SET @Count = @Count - 1
END

set rowcount 0
drop table #Const_Table