Drop constraint in ms sql

DECLARE @sql NVARCHAR(MAX)
WHILE 1=1
BEGIN
    SELECT TOP 1 @sql = N'alter table tbloffers drop constraint ['+dc.NAME+N']'
    from sys.default_constraints dc
    JOIN sys.columns c
        ON c.default_object_id = dc.object_id
    WHERE 
        dc.parent_object_id = OBJECT_ID('tbloffers')
    AND c.name = N'checkin'
    IF @@ROWCOUNT = 0 BREAK
    EXEC (@sql)
END

Source: stackoverflow.com

Similar codes

0 vote139 views1 answer
Is not numeric sql
SQL
0 vote136 views1 answer
No suitable driver found for sqlite
SQL
1 vote128 views1 answer
Set autoincrement to 0
SQL
0 vote124 views4 answers
User defined function sql
SQL
0 vote151 views1 answer
When mysql server would not work in xampp
SQL
8 votes123 views2 answers
Between operator
SQL
0 vote143 views1 answer
Sql insert from excel
SQL
10 votes78 views1 answer
Oracle view dependencies
SQL
0 vote139 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote141 views2 answers
Drop table with constraints
SQL